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

keeeirs10
keeeirs10 Member
in Charting

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

Screen Shot 2022-03-01 at 11.20.08 AM.png


Thanks,

Keirsten

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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
    MarkSnodgrass Coach
    Answer ✓

    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.

Categories