Missing data points

learnDomo

Hi

I am pulling data into card but some months that had no activity are missing and so the running total is not pulled in for that particular month. How do I ensure that the all months are populated including zero values

ColemenWilson

You'll need to use a calendar dataset. There is one in the Domo Dimensions connector. The calendar dataset will have every date for your card. You then need to join your data with the calendar dataset so there is data for every month you are displaying. Domo only plots what is in the data, so if 0's don't show in your data they won't be plotted.

MarkSnodgrass

You can follow the steps in the video to fill in missing dates:

https://youtu.be/9iNpzSL5V6U

ColemenWilson

You'll need to use a calendar dataset. There is one in the Domo Dimensions connector. The calendar dataset will have every date for your card. You then need to join your data with the calendar dataset so there is data for every month you are displaying. Domo only plots what is in the data, so if 0's don't show in your data they won't be plotted.

MarkSnodgrass

You can follow the steps in the video to fill in missing dates:

https://youtu.be/9iNpzSL5V6U