Custom Table Calculations

The following functions are ones that, instead of being calculated in a measure pill (the green pill-shaped icon used in a Tableau worksheet), utilize a calculated field.

INDEX

An INDEX function allows the user to calculate a row-level count for a table. This index starts at 1 and continues the count down the table. There will not be a recount per section unless you specify how the table calculation is calculated.

Figure 3.36: Example table of rankings

The function of this calculation is INDEX().

You can create this calculation to find a specific row. For example, if you needed to filter the first 25 rows of data, you could use a boolean calculation via INDEX() <= 25. The following screenshot shows the result:

Figure 3.37: Table highlighting the first 25 rows

Rank

There are multiple ways in Tableau to sort the data in a field into ascending or descending order, and one method is by...