The percentile function calculates the percentile of the values in measure, grouped by the dimension that's in the field well. There are two varieties of percentile calculation available in Insights:

  • percentileCont uses linear interpolation to determine result.

  • percentileDisc (percentile) uses actual values to determine result.

The percentile function is an alias of percentileDisc.