You'll need to use a calendar dataset. There is one in the Domo Dimensions connector. The calendar dataset will have every date for your card. You then need to join your data with the calendar dataset so there is data for every month you are displaying. Domo only plots what is in the data, so if 0's don't show in your data they won't be plotted.
Beast Mode
Beast Mode
How to show series of dates not closely tied to your data point?
Gee_Escuadro
Member
in Beast Mode
Is there a way to show a series of dates in sequential order (either daily, weekly, monthly, etc.) without the date being closely tied to a particular data point?
0
Best Answer
-
There's a calendar card-type, if you just want a list of dates.
But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in your dataset. You need a row with that date and a null value for what you're graphing, plus a value that matches anything you're filtering on. You can get that by joining your data with Domo's calendar dataset. You might search through past community forum posts to find something that best matches your situation, because this is a question that has been asked/answered a fair number of times in different iterations. Here's one with a particularly thorough explanation from @MarkSnodgrass:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Answers
-
There's a calendar card-type, if you just want a list of dates.
But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in your dataset. You need a row with that date and a null value for what you're graphing, plus a value that matches anything you're filtering on. You can get that by joining your data with Domo's calendar dataset. You might search through past community forum posts to find something that best matches your situation, because this is a question that has been asked/answered a fair number of times in different iterations. Here's one with a particularly thorough explanation from @MarkSnodgrass:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1 -
Thank you 😊
0 -
Here is the video that is referenced in the earlier post.
**Check out my Domo Tips & Tricks Videos
**Make sure to
any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 788 Beast Mode
- 78 App Studio
- 43 Variables
- 744 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive