I am trying a way to get relative differential trend ( timeseries) for the below scenario,
Transactions per seconds which is the sum of the hit and read here
So there is one view v1 which has reads and hits columns
And the value for the columns is cumulative – since startup of the DB .
So in order to draw only last increment
In NR One dashboard – How can we read current value and get the diff from the prev cumulative sample and show only the delta in timeseries trend please?
Hits Reads timestamp
557097484 12350 September 05, 2019 14:53:06
564011194 12365 September 05, 2019 14:54:06
564014176 12365 September 05, 2019 14:55:u6307:
so @ September 05, 2019 14:53:06 I am interested to get the delta of this timestamp and previous timestamp September 05, 2019 14:54:06 for the column values … so I should get ( 557097484 - 564011194 ) and ( 12350 - 12365 ) … and so on …,.
In SQL world we used to use lag/lead sql analytics feature and keen to see the equivalent here please.
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.