Missing data points

learnDomo
learnDomo Member
in Cards, Dashboards, Stories

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

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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.

    If I solved your problem, please select "yes" above

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    https://youtu.be/9iNpzSL5V6U

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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.

    If I solved your problem, please select "yes" above

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    https://youtu.be/9iNpzSL5V6U

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories