This blog is inspired by blog: Top 15 Tableau LOD Expressions (Practical Examples).
Tableau LOD (Level of Detail) Expression is one of the most powerful tools to achieve amazing results in building dashboards. In this series of blogs, we will walk through 15 different use cases to demonstrate the usage of LOD expression.
Since this is a series blogs, please use the navigation below to jump to the one you need quickly:
- Cohort Analysis
- Customer Order Frequency
- Daily Profit KPI
- Percentage of Total
- New Customer Acquisition
New Customer Acquisition
I have to say there’re multiple methods of calculating the percentage of total with similar effort and LOD is only one of them. In this example, we still connect to Sample-Superstore dataset, and we want to have a look at the sales performance for each Sub-category within its Category. So let’s start this task step by step:
1. We put two dimensions Category and Sub-category to Rows, and Sum of Sales to Columns. If we select the Marks card as Bar, we can get the result as below:

