Advanced analytics

Insight allows you to use different types of aggregations for your data. You can add percentile rank (see Transform data), sub-aggregations, or reference lines. Percentile rank is a type of series transformation, sub-aggregation values are shown below all the drill down values as a separate row (or rows) of data, and reference lines are shown as lines on the chart.