Is there a way to show 0 values in line graphs?

Options

Hello!

I am looking for a way to continuously graph data, even when there are 0 values. When creating cards, I see breaks in line graphs when there is NULL data. Any ideas??


Thanks,

Keirsten

Tagged:

Best Answer

  • MarkSnodgrass
    Answer ✓
    Options

    Domo can't plot anything for something that isn't there. It would be nice if there was something you could do in Analyzer, but you will need to go to your ETL and join it to a date table, such as the Domo Dimensions Calendar to create entries for every date. You can then replace nulls with zeros in your ETL for those dates and then your card will not have gaps in your lines.

    **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

  • MarkSnodgrass
    Answer ✓
    Options

    Domo can't plot anything for something that isn't there. It would be nice if there was something you could do in Analyzer, but you will need to go to your ETL and join it to a date table, such as the Domo Dimensions Calendar to create entries for every date. You can then replace nulls with zeros in your ETL for those dates and then your card will not have gaps in your lines.

    **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.