A benchmark metric enables you to create calculations that remain visible regardless of any security permissions applied. A benchmark calculated metric can still be affected by other attributes and manipulations you add to your report.
The image below displays the quarterly results for the metric Tickets. A benchmark metric is added as a trend line to show the average by group.
To add a benchmark metric
- In Query Builder, open the Calculations menu ().
- Click Benchmark metric.
- Enter the name of your benchmark metric.
- Benchmark metrics are written in the same language as standard calculated metrics. Explore will auto-complete formulas as you type.
- Click Save.
- Add your benchmark measure to the Metrics panel.