Skip to content

    • Charting

    Charting

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

    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

    • 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

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories