Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

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: