Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Feature Idea: Differential ( delta ) between the samples

feature-idea

#1

Hi
I am trying a way to get relative differential trend ( timeseries) for the below scenario,

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

Thanks
Manoj Kaparwan


New Relic Edit

  • I want this too
  • I have more info to share (reply below)
  • I have a solution for this

0 voters

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.


#2

Hey @Kaparwan.Manoj - I’ve spoken to some colleagues on this and the consensus is that this is not currently possible.

I’ll get a feature idea opened for you - for the ability to get deltas from 2 values in a cumulative calculated value.

I’ll also get a feature idea poll started on this thread for others to vote on. :slight_smile: