Learning Tableau 2019 - Third Edition

Custom Table Calculations

Before we move on to some practical examples, let's briefly consider how you can write your own Table Calculations, instead of using Quick Table Calculations. You can see a list of available Table Calculation functions by creating a new calculation and selecting Table Calculation from the drop-down list under Functions.

For each of the examples, we'll set Compute Using | Category. This means Department will be the partition.

You can think of Table Calculations broken down into several categories. The following Table Calculations can be combined and even nested just like other functions.