Amazon QuickSight
User Guide

percentile

The percentile aggregation computes the nth percentile of the specified measure, grouped by the chosen dimension or dimensions. This function helps you understand the distribution of your data.

Syntax

percentile(measure, percentile)

Arguments

measure

The argument must be a measure. Null values are omitted from the results. Literal values don't work. The argument must be a field.

percentile

The percentile value can be any double literal between 0 and 100. A percentile value of 50 computes the median value of the measure.

On this page: