Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Line graph zero values

Hi,

I have the below line graph and I would like to include data point as zero when there are no late trades. Currently weeks 8 and 14 are zero, however they don't appear on the graph.

Any help would be much appreciated.

Regards,
Daniel

 

Labels (1)
4 Replies
Kushal_Chawda

@danielnevitt Make sure that Supress zero value option is enabled, If not try to enable that option. Still doesn't work then follow below approach after enabling suppress zero value option

add sum({1}0 ) to your measure for eg. if your line chart measure is "=Sum(Value)", you need to write measure as below

=Sum(Value) + sum({1}0)

 

danielnevitt
Creator
Creator
Author

Hi Kushal,

Thank you for your reply.

Unfortunately the graph now shows all data and ignores my expression:

Count(DISTINCT {<[Late/OnTime]={`Genuine Late`,`Late`}>}trade_num)+ sum({1}0)

Do you have any ideas how I can make the date continuous?

Thanks,
Daniel

Kushal_Chawda

@danielnevitt  can you send screenshot of problem?

Sabrina_V
Partner - Creator II
Partner - Creator II

Do you have the week missing in your model ?