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: NRQL Derivative Function

nrql
feature-idea
derivative
follow-up
mod_queue
sla_breaching

#1

Hi,
I have a cumulative value which I store to insights every minute.
I would like to get the derivative of the value but it there is no derivative function in NRQL. Is this possible/forthcoming?

Eg Dynamic_sql_stmts is a cumulative count since the db started. I’d like to know dynamic_sql_stmts per minute.

SELECT average(DYNAMIC_SQL_STMTS) FROM DB2Stats SINCE 30 MINUTES AGO TIMESERIES 1 minute


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

Try max - min for a hack. You might have to widen your interval.


#3

@charekc and @eschumac - Thank you for pitching in the community! I have created a poll so we can start collecting votes for this! :blush:


#4

Hi all,

I’m afraid that the max() - min() hack will not work for me, as I have more than one host (so max and min will be selected from all values for all hosts). I want to calculate the difference between max and min for a host and then sum up all the differences for all hosts. This feature would be really handy for this I think.