Displaying Zero value fields in charts over time

Chris_Thebe

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?

GrantSmith

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.

GrantSmith

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.