topic Re: Line chart show the latest value instead of zero in App Development

Line chart show the latest value instead of zero

Ax — Sun, 13 Mar 2022 10:15:54 GMT

Hi,

I have a line chart where the dimension is Year Month and the measure is Price.

For future months the price is 0 but instead of it, I would like the line chart to show the last positive value for the future months.

For some reason, FirstSortedValue or Sum does not work with measure Price.

Thanks!

Re: Line chart show the latest value instead of zero

Taoufiq_Zarra — Sun, 13 Mar 2022 11:29:12 GMT

@Ax can you share a sample data and the expected output ?

Re: Line chart show the latest value instead of zero

Ax — Sun, 13 Mar 2022 12:32:33 GMT

Currently the line chart is showing

Year Month	Price
Jan 2022	100
Feb 2022	120
Mar 2022	0
Apr 2022	0

What I would need is to copy the last price to the future months

Year Month	Price
Jan 2022	100
Feb 2022	120
Mar 2022	120
Apr 2022	120

I don't know why but the Sum or FirstSortedValue do not recognize the 'Price' so I can't use those functions.

However, when I use it inside if function it recognizes it. For example IF(Price > 0, Price) works. I would just need somehow add to the else statement the most recent value that is not 0.

Re: Line chart show the latest value instead of zero

Ax — Tue, 22 Mar 2022 19:51:17 GMT

I could not use the pre-calculated master item in the expression. When I copied the formula for the master item instead of using it, it worked.