I have a TSVB metric w/ a cumulative sum that shows the "Score" for the environment and I'm looking at adding a 2nd metric to the same visualization to display +/- offset (score change) over the last 7 days. Could someone please guide me on which specific function and criteria I need to represent this?
A derivative aggregation of a cumulative sum seems to be the answer here. The problem I have now is that I don't have data for every single day so the offset 7d does not truly represents 7 consecutive days, it represents 7 days where I have data. Need to figure out how to approach this last part ...
Are you just saying you want the serial difference from 7 Days ago?
So today is 95 last week was 98 so show -3?
Day before was 77 and 7 days before was 85 so show +8?
Pretty Sure you can do that in Lens with Serial Difference and Offset... take a look, I will to
Think use Lens formula
Now cumulative Sum let me see..something like
Thanks @stephenb I will this a try