Hi,
i have a situation where when i use actions on the dashboard view between two bar charts.
Example :
Chart 1 : shipped status
Chart 2 : Monthly view on city
when i create action on dashboard and click on particluar shipped status like shipped early
i see few months there is data and for few months no data.
is there way i can fill values for the months with no data from previous month till a month has any value in it?
i have created a such situation on superstore data and shared it, thanks in advance for the help
Good morning @raghu h r
this ifnull(COUNT([Migrated Data]),PREVIOUS_VALUE(0)) will fill the null if the null is within the range of the fitst date record and last date record in the filtered view -
if the date you want to fill is before the first real filtered date record or after the last filtered data record you will need to scaffold the data to provide a real record for each date in the range - confused? see the https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/ or the video at https://youtu.be/uUgXnWJ2iEs the 3rd example is closest to what you are doing and the last couple of paragraphs will explain what is going on (but you need to read the entire post to understand it)
see the attached
