How to build a ranking table

What is a ranking table?

Ranking table displays columns of data, where there is always one column ordering all the other columns in the table by default.

When is it used?

A ranking table is used to show a relationship between a set of items: for any two items, the first is either 'ranked higher than', 'ranked lower than' or 'ranked equal to' the second. For this reason the ranking table must have at least two columns.

It can be used to sort values from the highest to the lowest or vice versa, for example to establish the best and worst selling performers of the month.

How to configure a ranking table

The user selects the variables that will be shown as columns in the table. The order in which the columns are selected is the order in which they will appear in the table. The first column selected is the main subject of your table, the data that works as the core of the query (e.g. Country by sales). The following fields should be defined for each column:

• Column: the variable the user wants to be displayed.

• Group by: if selected, the column will be used to group by the data. Rows are grouped that have the same values into summary rows, like "customers grouped by country".

• Column type: refers to the data type and its related unit of measure. Depending on the data, it can be numeric, weight, power, distance, currency or percentage. For example, you would select "power" if you are measuring the total energy produced by each energy plant.

• Create bin: if the column has been selected for the Group by, and its type is numerical, the user has the possibility to create bins.

• Aggregation: if timestamp type is selected, you can decide the level of aggregation, e.g., daily or monthly.

• Function: the aggregation function that will be applied to the data that is not selected in the group by. If the column is not a numerical data type the function will be Identity.

Liked this one? Find out also how to build a single line chart!