Purpose
This measure helps business users understand the distribution and dispersion of values within a dataset. The First Quartile (Q1) identifies the value below which 25% of the observations fall, providing insight into the lower 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 First Quartile highlights the threshold separating the lowest-performing 25% of values from the remaining dataset. This information supports identifying outliers, evaluating variability, and establishing performance benchmarks.
Definition
The measure calculates the 25th percentile of a metric within the Agent’s filtered scope. When the dataset is divided into four equal, rank-ordered groups, the First Quartile represents the upper boundary of the lowest quartile.
Business Formula
First Quartile = 25th Percentile(metric)
Agent Expression
PERCENTILE_CONT(Metric, 0.25)