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