The RecorderNumStateDuration data model encapsulates aggregated duration statistics for a numeric parameter over a specified time range. It includes the total time spent exceeding a maximum threshold, falling below a minimum threshold, and remaining within the defined range, as well as the corresponding percentages of each interval. These values are obtained from a SQL query that calculates duration differences between consecutive data points using window functions.
| Key | Type | Value |
|---|---|---|
| parameterId | String | Identifier of the numeric parameter. |
| overMax | String | Duration spent above the maximum threshold. |
| underMin | String | Duration spent below the minimum threshold. |
| between | String | Duration spent between the minimum and maximum thresholds. |
| overPercent | Float | Percentage of total time above the maximum threshold. |
| underPercent | Float | Percentage of total time below the minimum threshold. |
| betweenPercent | Float | Percentage of total time within the threshold range. |