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

Hi @azulgrana
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

differences(count(shift='7d'))

Now cumulative Sum let me see..something like differences(cumulative_sum(sum(cloudfoundry.rtr.bytes_sent)),shift='7d')

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.