In this article
1: Benchmark Calculation Panel
Use the Benchmark panel to compare one result to another. You can calculate the difference using three available methods:
- Units
- Percentage share
- Index/Conversion rate
These calculations help you evaluate change or performance across data points in your chart. You can apply them across items in either the legend or the axis, and choose how comparisons are made (e.g., to the first, last, or previous data point).
To apply a benchmark calculation to your chart:
Select a calculation type from the Calculation list: Units, Percentage share, or Index/Conversion rate.
Decide whether to display the original values. To show only the benchmark values, enable the Show only benchmarks setting. This will automatically hide the original results.
Select the benchmark direction from the Benchmark between list. Choose to calculate across either the legend, axis or series.
Note: The Benchmark between list does not displays if your chart only supports axis-based benchmarks.
Select a comparison point from the Comparison data point(s) list. This determines which data point the benchmark is measured against.
Choose whether to display the comparison point using the Comparison behavior setting.
Note: the comparison data point is always hidden if the setting Show only benchmark is enabled.
2: Benchmark Calculation Methods
2.1: Units
Use this option to calculate the difference in raw values between two results.
Formula:X - Y
Example: X = 50, Y = 80 → 50 - 80 = -30
2.2: Percentage Share
Use this option to calculate the difference as a percentage of the benchmark value.
Formula:(X - Y) / Y * 100
Example: X = 50, Y = 80 → (50 - 80) / 80 * 100 = -37.5%
2.3: Index/Conversion Rate
Use this option to calculate the conversion rate or index between two values.
Formula:X / Y * 100
Example: X = 50, Y = 80 → 50 / 80 * 100 = 62.5%
3: Comparison Options
Benchmark comparisons can be configured to:
- Compare a data point to the first, last, or previous point
- Compare across series in the legend or axis
This allows you to tailor the analysis to different use cases or trends.
4: Benchmark Examples
4.1: Benchmark Across Intervals Using Unit Calculation
In this example, the benchmark is applied across intervals (the axis items), where each data point is compared to the previous one using a Unit calculation.
The benchmark values indicate how the result for each brand has changed from the previous week, measured in percentage units.
4.2: Benchmark Compared to First Data Point Using Unit Calculation
In this example, the benchmark is applied across intervals (the axis items), with each data point compared to the first data point using a Unit calculation.
The benchmark values show how the result for each brand has changed, in percentage units, since the first week (2011-03 in this example).
4.3: Benchmark Across Brands Using Unit Calculation
In this example, the benchmark is made across brands (the legend items), with each data point compared to the next data point using a Unit calculation.
The benchmark values show how the result of Dapresy Telecom is performing compared to Sweet Talk.
4.4: Example 4: Displaying Only Benchmark Values
In all the examples above, the chart series shows the original values. The benchmark values appear only in the data value labels.
However, it is also possible to display only the benchmark values in the chart. When this setting is applied, the comparison data point is automatically hidden, as shown in the example below.
In this example, the chart on the left shows the original data without any benchmark calculations applied.
The chart on the right uses benchmark calculations across intervals (weeks), where each data point is compared to the first data point (week 2011-03).
The Show only benchmark setting is enabled, so the chart displays benchmark values instead of the original values. The bars represent the difference for Dapresy Telecom each week compared to the first week.