Broken Trend Chart With No Data
I am using a Monthly Trend chart, and because one month has no data, the line is broken and does not go to 0 connected. Is there a way to make the chart show 0 for the months that do not have data?
I have tried beast mode, dataflow with a calendar dataset left outer join, and it does not resolve the problem for some reason. I still see the gap.
Tagged:
0
Answers
-
I have learned what I did wrong. Even though I did join the calendar, I had to add Group BY to the data to correctly count the number of items per day so that the chart can show 0 if I had no items in a month. I will mark my question as resolved.
1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部