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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive