Skip to content

bottomk-others-max

Input Stack:
k: Int
stat: String
expr: TimeSeriesExpr
 ⇨ Output Stack:
TimeSeriesExpr
 
 

Select the bottom K time series based on a summary statistic and aggregate all remaining series into a single "others" line using maximum aggregation. This provides a way to focus on the lowest performers while showing the peak value among all excluded series.

Parameters

  • expr: A grouped time series expression (typically the result of :by)
  • stat: Summary statistic to rank by (see :stat for available options)
  • k: Number of bottom-performing time series to display individually

Behavior

  1. Ranking: Evaluates all time series using the specified summary statistic
  2. Selection: Selects the K series with the smallest statistic values
  3. Aggregation: Combines all remaining series using :max aggregation
  4. Output: Returns K+1 time series (K individual + 1 "others" maximum)

Examples

Show bottom 2 clusters by maximum value, with maximum of others:

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

name,sps,:eq,
(,nf.cluster,),:by,
max,2,:bottomk-others-max

Since: 1.7