Purpose
This measure is used to understand the dispersion and variability of values within a dataset. The Interquartile Range (IQR) focuses on the middle portion of the data, making it a robust indicator of spread that is less sensitive to extreme values.
Business Context
The IQR measures the range within which the middle 50% of observations fall. By excluding the lowest and highest quartiles, it provides a clear view of typical variation and supports comparative analysis, outlier detection, and performance consistency assessment across business segments.
Definition
The measure calculates the difference between the third quartile (Q3) and the first quartile (Q1) of a metric within the Agent’s filtered scope. Equivalently, the IQR is the difference between the 75th percentile (P75) and the 25th percentile (P25).
Business Formula
Interquartile Range (IQR) = 75th Percentile of the Metric − 25th Percentile of the Metric
Agent Expression
PERCENTILE_CONT(Metric, 0.75) - PERCENTILE_CONT(Metric, 0.25)