Skip to content

Median

Median(column) · Aggregation

The 50th percentile (PERCENTILE_CONT(0.5) where the database supports it). Not available on MySQL, SQL Server, or BigQuery sources — SquareX fails loudly with SQX010 rather than approximating.

MedianOrderValue := Median(Sales.Amount)
  • Non-additive — rejected under YTD/RollingSum (SQX015).