topic Re: Line graph zero values in App Development

Line graph zero values

danielnevitt — Mon, 17 Apr 2023 17:54:20 GMT

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

Re: Line graph zero values

Kushal_Chawda — Mon, 17 Apr 2023 21:58:23 GMT

@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)

Re: Line graph zero values

danielnevitt — Fri, 21 Apr 2023 08:37:09 GMT

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

Re: Line graph zero values

Kushal_Chawda — Fri, 21 Apr 2023 13:28:32 GMT

@danielnevitt can you send screenshot of problem?

Re: Line graph zero values

Sabrina_V — Fri, 21 Apr 2023 14:04:59 GMT

Do you have the week missing in your model ?