Aggregations and statistical measures
In the visualizations and various tools, calculations are performed that use aggregation and statistical measures.
For a description of each measure, see the corresponding section.
Note: For measures where a large statistical selection is needed, the
result from a calculation may vary with the number of available values.
- Sum
- Average (Avg)
- Count
- Unique Count
- Min
- Max
- Median
- Standard Deviation (StdDev)
- Standard Error (StdErr)
- Variance
- Lower endpoint of 95% Confidence Interval
- Upper endpoint of 95% Confidence Interval
- First Quartile (Q1)
- Third Quartile (Q3)
- Lower Adjacent Value (LAV)
- Upper Adjacent Value (UAV)
- CountBig
- Unique Concatenate
- Concatenate
- First
- GeoMetricMean
- Interquartile Range (IQR)
- Last
- Lower Inner Fence (LIF)
- Lower Outer Fence (LOF)
- Mean Deviation
- Median Absolute Deviation
- Most Common
- Outlier Count (Outliers)
- 10th Percentile (P10)
- 90th Percentile (P90)
- Outlier Percentage (PctOutliers)
- Product
- Range
- Upper Inner Fence (UIF)
- Upper Outer Fence (UOF)
In the column selectors of some visualizations there are also a number of aggregation measures available that are in fact shortcuts to expressions. See below for a description:
- Cumulative Sum
- Moving Average
- Difference
- Difference %
- Difference Year Over Year
- Difference % Year Over Year
- % of Total
- Year to Date Total
- Year to Date Growth
- Change Relative to Start
- Change Relative to Fixed Point
- Compound Annual Growth Rate
See Node navigation and Shortcuts to frequent custom expressions for more general information about writing custom expressions with OVER and THEN.