Forum Discussion

kbansal's avatar
kbansal
Frequent Visitor
4 years ago
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...
Need Help
  • KNP's avatar
    KNP
    4 years ago

    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

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

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