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

levi_kim
levi_kim Member
in Charting

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!

image.png

Best Answer

Answers

  • MichelleH
    MichelleH Coach

    @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.

  • levi_kim
    levi_kim Member

    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.

  • ArborRose
    ArborRose Coach
    Answer ✓

    You could do a recursion to store values to an archive each week. Then poll the archive to identify changes.

    https://domo-support.domo.com/s/article/360057087393?language=en_US

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories