In data analysis, numbers alone are not always easy to understand. Sometimes, showing data as a percentage makes it much clearer. This is where the percentage of total concept becomes very useful.
In the Tableau data visualization tool, you can easily convert your raw numbers into percentages. This helps you understand how much each part contributes to the overall total.
Recently, I created a stacked bar chart to show sales by product category for each region. In this chart, when I tried to show the percentage, it displayed the percentage of the running total rather than the percentage of the total.
Then, using the quick table calculation, I was able to display the percentage of total on the Tableau stacked bar charts.
Along with this, I also found other ways through which we can calculate the percentage of total, which use WINDOWS_SUM, INCLUDE LOD and EXCLUDE LOD.
In this tutorial, I will explain how to calculate the percentage of the total in Tableau using four different methods.
What is the Percentage of Total in Tableau?
In Tableau, the percentage of total calculates the proportion each part contributes to the whole by dividing a measure’s value by the sum of that measure for all parts.
We can apply this quickly using Tableau’s Quick Table Calculation feature, or create custom calculations with