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 ...