Aggregate FunctionsMetrics
rate
Computes the per-second rate of change for a counter metric, handling counter
Syntax
rate(value, timestamp)Parameters
Prop
Type
Returns: real
Syntax
rate(value, timestamp, per_duration)Parameters
Prop
Type
Returns: real
Examples
Example 1
datatable(ts:datetime, counter_value:real)[
datetime(2024-01-01), 10.0,
datetime(2024-01-02), 20.0,
datetime(2024-01-03), 30.0
]
| summarize rate(counter_value, ts)| rate_counter_value (real) |
|---|
| 0.00011574074074074075 |
Example 2
datatable(ts:datetime, counter_value:real)[
datetime(2024-01-01), 10.0,
datetime(2024-01-02), 20.0,
datetime(2024-01-03), 30.0
]
| summarize rate(counter_value, ts) by bin(ts, 1d)| ts (datetime) | rate_counter_value (real) |
|---|---|
| 2024-01-01T00:00:00Z | 0.0 |
| 2024-01-02T00:00:00Z | 0.0 |
| 2024-01-03T00:00:00Z | 0.0 |