New Topic

Community Topic Question Report Builder

David Registro

APAC SD Team

Assigned

Yellowfin Support Desk

APAC SD Team

Category Report Builder

Product Version 7.3

How to avoid line chart to show drop due to null values of future?

Sumit shared this question ago

Answered

Hi,

I am trying to create comparison of Revenue of todays vs yesterday on hourly basis.

for example in attached screenshot 'running total of rev1' is todays revenue(Purple line). This line shows a drop starting from 7th hour since the data is not yet in for 8th hour.

Is there a way I can hide/edit this drop till the time data is populated for future hours?

Thanks

Files:

The same question

Replies (4)

Guest ●

Hi Sumit,yes, it sounds like the Skip option for the Null Behaviour setting might do the trick for you:

/DxqUv47h7MnqAAAAAElFTkSuQmCCAA==

I have tested this out and it seems to work for me, see the blue line below drops to zero for the last point, this is because there is a null value there:

/9jUAAAAASUVORK5CYIIA

then after I set the Skip option to be on, it doesn't drop to zero anymore:

Please let me know if this helps you meet your reporting requirements.

regards,

David

Reply URL

Sumit ●

Thanks David,

It worked!

Sumit

URL

Guest ●

that's great news Sumit, thanks for letting me know!

Reply URL

Syed Rahman ●

Hi David,

This feature isn't available for Overlay Chart :(

Regards,

Syed

Reply URL

Guest ●

Hi Syed Rahman,

yes that's correct, and it isn't because of a bug - it just hasn't been implemented yet. So please feel free to raise an Idea in the Yellowfin Community to request said feature.

regards,

David

Reply URL