Row level, aggregate level, table level

There are three levels of calculations in Tableau: Row, Aggregate, and Table. To understand how these three levels function, it's important to know the Tableau process flow.

We can see the process flow in the following diagram:

Let's follow the flow to understand where the three levels of calculations take place. We'll do so with an example that considers the Number of Records and Quantity fields. Assuming we're using SQL, consider the following calculation types, calculated fields, and queries. Note that the SQL is slightly simplified for the sake of this example.

Let's take a deeper look at the three ...

Get Mastering Tableau 2019.1 - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.