Aggregate FunctionsMetrics
deriv
Computes the derivative (rate of change) for a gauge metric. Unlike rate(),
Syntax
deriv(value, timestamp)Parameters
Prop
Type
Returns: real
Syntax
deriv(value, timestamp, per_duration)Parameters
Prop
Type
Returns: real
Examples
Example 1
datatable(ts:datetime, gauge_value:real)[
datetime(2024-01-01), 10.0,
datetime(2024-01-02), 20.0,
datetime(2024-01-03), 30.0
]
| summarize deriv(gauge_value, ts)| deriv_gauge_value (real) |
|---|
| 0.00011574074074074075 |
Example 2
datatable(ts:datetime, gauge_value:real)[
datetime(2024-01-01), 10.0,
datetime(2024-01-02), 20.0,
datetime(2024-01-03), 30.0
]
| summarize deriv(gauge_value, ts) by bin(ts, 1d)| ts (datetime) | deriv_gauge_value (real) |
|---|---|
| 2024-01-01T00:00:00Z | 0.0 |
| 2024-01-02T00:00:00Z | 0.0 |
| 2024-01-03T00:00:00Z | 0.0 |