How to show series of dates not closely tied to your data point?
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?
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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive