Is there a way in Domo to plot date and time against a *fixed and gapless* x-axis?
When we plot by hour, we want all 24 hours, not just any that are present in our DataSet. For the gaps, we would like a 0.
I set up a simple dummy DataSet, and can't find a way to make this work.
I found this thread from four years ago:
https://dojo.domo.com/t5/Card-Building/X-Axis-Interval-hourly/m-p/11271
Rings a bell, we're already injecting 0-value placeholder rows to populate bins in some of our DataSets. But what's cropped up now are cases where filtering excludes those rows, breaking the x-axis' continuity. Imagine this simple DataSet:
When What For How Many
2020-06-09 00:05:00 Receive Building A 1
2020-06-09 00:05:00 Inspect Main 0 <-- Placeholder example
2020-06-09 00:07:00 Receive Building A 3
2020-06-09 00:12:00 Reject Building A 4
2020-06-09 00:13:00 Pack Main 5
To make the 0-value injection hack work, in this case, we would need to add 0 value rows for *every* combination of hour, What and For. Leaving out that the data explodes out, there are some problems with this:
- It's no longer straightforward to change intervals.
- What and For, in this example, are both dynamic and continually evolving. Meaning, new items appear all the time. To make the system work properly, we would then have to retrofit blank rows back to our start date for new "What" and "For" values.
- And "What" and "For" are just made-up, we have more such fields in the real world, only amplifying the problem.
Is there a straightforward way to get Domo to use a fixed x-axis for hour, date, etc? The workaround above is fairly unattractive, and our situation seems like it ought to be commonplace. I'm hoping that I've missed the obvious! Please let me know. It's no problem for us to pre-calculate and include hour of day, day of week, day of month, etc., if that helps.
Thanks