The ranking calculation is also available in the Cross Table tool. The rank can be based on any calculation type like mean values, percentage shares, count etc. and is highly flexible as the user can select if the rank shall be applied across columns or across rows and also within specific sub groups.
Here we have two examples of showing rank in the Cross Table tool. The rank in the left table is made across rows while the rank in the right table is made across columns.
The Ranking feature in the Cross Table tool works in the same way as in the StoryTeller table, so that the rank setup is defined in a new panel named “Rank”, which is available in the Calculation tab.
The following steps are selected to apply the ranking calculation to a table:
- Select if the Ranking will be applied on columns or on rows
- Select if the Rank will be applied in a certain sub group or across all items (all rows or all columns)
- Select if the Rank values will be shown on their own or if the Rank values will be shown together with the calculated result
The image below shows the Rank setup panel, each of the settings is described further down.
In the “Rank between” list you define if the rank will be applied across columns or across rows, see examples below. In the left table below the rank is set across columns, in the right table the rank is across rows.
In the Rank object list we define if the rank will be applied across all rows/columns or if it will be applied within a specific object such as an Interval, Filter compare, Question etc. In the example below the table shows Interval and Regions in columns. In this case the rank can be applied across all columns, within the Regions 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 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
Show rank in same row or in new row
Select if the rank should 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.
Enable Ranking in the Cross Table tool
The Administrator can select, in the Setup screen of the Cross Table tool, if the Ranking panel will appear or not. The Rank panel is displayed by default in newly created Cross Table tool. Here we see where the Administrator can apply the Rank setting.