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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 636 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 701 Automate
- 182 Apps
- 457 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive