How to build 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.

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.

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!
If you have any questions about crystal’s features, you have encountered a problem or you would like to share your feedback, contact us using this form.
Copy link
On this page
What is a ranking table?
When is it used?
How to configure a ranking table