Purpose
This measure helps business users understand the distribution and dispersion of values within a dataset. The Third Quartile (Q3) identifies the value below which 75% of the observations fall, providing insight into the upper range of performance for a given metric.
Business Context
Quartiles are commonly used in performance analysis and benchmarking to evaluate how values are distributed across a portfolio. The Third Quartile highlights the threshold separating the highest-performing 25% of values from the rest of the dataset. This insight supports performance benchmarking, variability analysis, and identification of high-performing segments.
Definition
The measure calculates the 75th percentile of a metric within the Agent’s filtered scope. When the dataset is divided into four equal, rank-ordered groups, the Third Quartile represents the upper boundary of the third quartile.
Business Formula
Third Quartile (Q3) = 75th Percentile of the Metric
Agent Expression
PERCENTILE_CONT(Metric, 0.75)