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 to like any users posts that helped you and accept the ones who solved your issue.**2
Answers
-
Thank you! It worked!
2
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有