Skip to content

stat-total

Input Stack:
 ⇨ Output Stack:
TimeSeriesExpr

Filter helper that represents the total (sum) statistic of the input time series. This is a placeholder that gets automatically replaced with total,:stat when used with :filter. It allows filtering based on the sum of all datapoints in each time series without having to duplicate the input expression.

Examples

Filtering series by cumulative volume:

BeforeAfter
name,sps,:eq,
(,nf.cluster,),:by

name,sps,:eq,
(,nf.cluster,),:by,
:stat-total,
1e6,:gt,
:stat-total,
4e6,:lt,
:and,
:filter

This filters to show only time series where the sum of all datapoints is between 1,000,000 and 4,000,000.

  • :stat - Base statistics operation (stat-total represents total,:stat)
  • :filter - Filtering operation that uses stat helpers
  • :stat-count - Filter by number of datapoints
  • :stat-avg - Filter by average values