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!