How can I make a historical/week over week chart without a provided date field?

Hi all,
I want to make a new but related chart that shows the trend of the SUM of total value week over week. The problem is that I do not have an available Date field in my dataset/ETL except for Item Creation Date which does not seem useful. Also, this total value field is a calculated Beast Mode: (safety stock qty*item cost).
The red arrow is pointing to the Total Value Summary Number which is what I'd like to see changes for week over week. How can I show the changes week over week? Any tips on how I can do this in ETL, Analyzer or Beast Mode would be greatly appreciated. I whited out sensitive information but hopefully the screen cap gets the message across. TIA!
Best Answer
-
You could do a recursion to store values to an archive each week. Then poll the archive to identify changes.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **2
Answers
-
@levi_kim This will largely depend on your data and how it's ingested in Domo. For example, are new rows added a day/week at a time where you can use an ETL to add a relative date field to the new rows? It will also be helpful to review the other columns you have available that could be used to infer a date, like period or week number.
0 -
Hi @MichelleH ,
I wouldn't say new rows are added on a regular basis but I would like to track any changes whether that be new rows or changing quantities or prices which affect total value. I've never tried adding a relative date field to new rows. Do you have any resources that could help? Or any advice on tracking changes in price and quantity in existing rows? I will take a look at other date related columns to see if it's possible. Thank you.
0 -
You could do a recursion to store values to an archive each week. Then poll the archive to identify changes.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **2
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive