Q1

This metric is not supported in MySQL.

Definition

Quartiles divide all non-NULL values in the column within the latest partition into four equal parts based on value: Q1 represents the 25th percentile.

Source

data (numeric)

Computation

• For data sources supporting exact percentiles (e.g. PostgreSQL’s PERCENTILE_DISC(0.25)), Soda uses that function.

• For data sources that provide approximations (such as BigQuery, SQLServer, Redshift and Trino), Soda uses those approximated values.