Benchmark calculations can be made across series* in charts and tables which makes it possible for more advanced comparisons. As an example, you can now compare result of different types, like a percentage value with a numeric value, which is common when comparing survey results to external benchmark/norm/target values. Another example is that you now can compare the result of the last one month in tracker to, for example, the year to date result without having to compute additional variables.

*Series = The highlighted items in the image below.

Since the structure of data can be completely different between series, the comparison can be done by the cell index (cell A1 in series 1 is compared to cell A1 in series 2, and cell A2 in series 1 is compared to cell A2 in series 2, and so on and so forth) or by using a text match between the items in the different series. Below you see use cases of both the cell index and the text match comparison.


Here we see a basic example where the cell index has to be used as comparison logic. In this example the main series shows the top of mind and the in mind awareness for Dapresy Telecom and the sub series shows their target values (the target values are stored in numeric variables in this example). As no text match can be made between the series a cell index comparisons is applied, hence to that it is very important that the order of the items in both series is the same so the right values are compared to each other (cell A1 in series 1 is compared to cell A1 in series 2, and cell A2 in series 1 is compared to cell A2 in series 2).



 

Here we see a basic example where the text match in rows has to be used as comparison logic. In this example the main series shows the top of mind awareness for the latest month, the sub series shows the same awareness result but for the year to date. The brands are ordered by value so a cell index comparison cannot be applied as the brands have different positions. 



 

 

4.1.1 Setup

To setup a Benchmark calculation between two or more series, follow these two steps:

  • In the section “Test between,” select the “Series” option (see image below).
    Note: This option is only available in the Main series and naturally only available if the chart/table has multiple series.


  • Select, in the Match by list, if the matching between series shall be made by the cell index or by a text match
  • Select calculation type (Units, percentage shares or conversion rates)
  • Select how the series will be compared to each other in the “Comparison type” list. The same options that you use when doing a regular benchmark calculations within a series are available (see some examples of this logic further down):  
  • Select comparison behavior, should the “comparison series” be hidden or not


Below you can see an example of each “Comparison type” option. The examples are based on a chart containing three series: Series 1, Series 2 and Series 3.


Example 1: Comparison type set to “All previous series”

  • Series 3 is compared to series 1 and series 2
  • Series 2 is compared to series 1

Example 2: Comparison type set to “Previous series”

  • Series 3 is compared to series 2
  • Series 2 is compared to series 1


Example 3: Comparison type set to “Next series”

  • Series 1 is compared to series 2
  • Series 2 is compared to series 3

Example 4: Comparison type set to “First series”

  • Series 3 is compared to series 1
  • Series 3 is compared to series 2