How to consider latest day sales for zero sales of that date in bar chart

[tulasiram_bitra]

Hello Guys,

I have taken Date as dimension and sum(Application_sales) as Measure. I need to consider last day sales if i dnt have sales on that day.

For example,

Date,                     Sales

01-04-2018 , 200

02-04-2018, 400

03-04-2018, 0

04-04-2018,0

05-04-2018, 600

Here, I need to show sales of 02-04-2018 ( 400 ) to 03-04-2018 and 04-04-2018 also. please find the attached image.

Please help me in this.

Thanks.. Tulasiram

[tresesco]

You can try loading like:

Load Date,

            If(Sales=0, Peek(Sales), Sales) as Sales

[tresesco · Accepted solution]

For front-end solution, try like:

[tulasiram_bitra]

Hello Tresesco,

It is working fine. Thank you so much.