Skip to content

    • Charting

    Charting

    Displaying Zero value fields in charts over time

    Member
    in Charting

    We have a chart based on data that is updated daily, however it only updates if the value has changed.

    We want to see the flat line, i.e. if there has been no changed over time.

    I've tried changed the chart types and even change it to year to date, it displays nothing i.e. no data

    Any ideas?

    Automated Tests Over Time.png

    Best Answer

    • Coach
      Answer ✓

      Domo visualizes data on a row by row basis so if there's no data for a given month it won't show anything. You'd need to restructure your data so that every month has a value. You could utilize the Date dimension dataset, filter to the granularity you need and then left join your dataset to the date dimension dataset. Once you have that then you could fill in the missing values.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      Domo visualizes data on a row by row basis so if there's no data for a given month it won't show anything. You'd need to restructure your data so that every month has a value. You could utilize the Date dimension dataset, filter to the granularity you need and then left join your dataset to the date dimension dataset. Once you have that then you could fill in the missing values.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    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