Before delving deeper into LOD calculations, it is first important to understand Tableau's order of operations, as this will guide our conversation, seeing where this new topic fits in.
Tableau's order of operations
Surprising results
Especially when coming to Tableau from Excel or other BI tools, one is sometimes at a loss when dealing with Tableau's order of operations. What can seem intuitive is not always what is reflected. Applying the wrong type of filter, or not using the proper calculation, will result in meaningless results.
The following is one such scenario. In the Global Superstore dataset, we create a data source filter for Country to show United Kingdom orders only, a dimension filter for State...