The rank setup is made in a new panel named Rank, in the Analysis tab. The setup of the Rank is very similar to the setup of the Benchmark calculation. The following steps are made:
- Select if the Rank values shall be shown only or if the Rank values shall be shown together with the calculated result
- Select if the Rank shall be made across Columns or Across rows
Select if the Rank shall be made in a certain sub group or across all items (all rows or all columns)
- Select if the Rank shall be shown for a specific item based on Optional filter selection
The image below shows the Rank setup panel, each of the settings is described further down.
Show only Rank
With the “Show only rank values” setting you define if the Rank values shall be shown standalone or together with the result. If the setting is active the Rank values are shown standalone, if it is deactivated both the result and rank values are shown.
The image below shows two examples, the table to the left displays both the rank and result and the table to the right display rank values only.
Note: When we show only rank value for no data or missing data, the table shows “-“ not 0
In the Dimension list you define if the rank shall be made across columns or across rows, see examples below.
In the left table below the rank is made across columns, in the right table the rank is made across rows.
In the Rank object list you define if the rank shall be made across all rows/columns or if it shall be made within a specific object such as an Interval, Filter compare, Question etc. In the example below the tables hows Interval and Regions in columns. In this case the rank can be made across all columns, within theRegions or within the months.
In the left table below the rank is made across all columns, in the right table it is made within Regions.
Show rank in same row or in new row
Select if the rank shall be shown in same row or in a new row, see examples below. This option is not available when only the rank values are shown in the table.
The table to the left shows the rank values in the same row, the table to the right shows the rank values in a new row.
Show ranked item as a suffix to the rank number, e.g. "3 of 15"
Here we see the setting to be enabled to show the number of ranked items in Storyteller table setup.
Show rank for specific item based on Optional filters
This function is used to only display the rank of a specific item selected in the Optional filter area, it could be a Hierarchical Filter, Variable subset or a Filter. This option is useful when the user for example not is allowed to see the rank of competitors or other hierarchical filter groups.
The image below shows a typical example, the report shows the result for the selected campaign in the“Campaign” filter but all campaigns have been used as a base for the ranking.
To setup a table like the one above where only the selected Campaign in the Optional was displayed do as the following:
Add Campaign as an Optional Filter
Add all the Campaign as Columns (or rows) in the table object (by using filter and compare)
Exclude the Campaign filter from the object in the Filter/Optional Filter panel
- In the Rank setup enable “Show rank for a specific item based on Optional Filter selection” and select the Campaign Filter in the “Select optional filter item”
If step number 3 above is not made the ranking will be based on the selected campaigns only and not all campaigns. This can be useful in use cases where the user can do multi selection in the campaign filter and wants to rank the selected campaigns to each other and not rank among all campaigns.
The same logic as described above can also be applied to Variable subsets.
For Hierarchical filters make sure that all the hierarchical filter groups that shall be used as base for ranking is shown in the table, that is done through the “Hierarchical group settings” in the Filter panel.