Forum Discussion
Solved
Missing Values in Running Total | Animated Running Bar Chart
Hi Everyone, I am working on an animated bar chart, and for that I created a running total measure. In my data, few 'Vendors' have no entry for some dates. And whenever a date is missing for a v...
Hi kbansal,
It is a common problem with running totals when the data is incomplete.
The best thing to do is tidy up the data. Start with a complete date range, from your date dimension ideally, and then merge >> left join the other data onto this. Make sure to replace the null values with zeros where appropriate and then the running totals should calculate as expected.
Hope this helps.
Regards,
Kim
lbendlin
Super User
Super UserPlease provide sanitized sample data that covers your issue, in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.