Aggregations Overview

Spotfire contains several visualizations and tools which calculate various aggregation measures or 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 (Var)

• Lower endpoint of 95% Confidence Interval (L95)

• Upper endpoint of 95% Confidence Interval (U95)

• 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 (MAD)

• 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 Advanced Custom Expressions and Using Expressions on Aggregated Data (the THEN Keyword) for more general information about writing custom expressions with OVER and THEN.