How to dynamically add "missing" data
Hi everyone,
I have a list of equipment that I want to attach to a date column for everyday of the year
Example:
The problem is that I have the list of equipment, I just don't know how to add the date column in domo for everyday this past month. I also want to continue creating date data for everyday that passes, so once the data is current, the equipment would link to today's date and store it in the data as historical data.
Can this be done?
Thanks
Best Answer
-
You can do this by creating a dataflow and adding the Domo Date Dimension dataset that provides all dates for whatever range you need. Look for it in the cloud apps. You would then add a constant of 1 to each dataset and join on that column so that you would get all dates. You can also use the filter tile to restrict what range you want.
This should get you what you want.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
Thank you! It worked!
2
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有