Last tested: Oct 14, 2020
Using Table Calculations, you can add a total column to a stacked bar chart. (Note: If your bar chart is not stacked, you can add a total column by simply checking the row totals box and pivoting on your dimension)
The method used is very similar to Method 1. Step 1 is the same as we want to filter for 1 extra timeframe - above, weeks - to be able to display the total in a separate column. We should also enable totals on that Explore query.
The table calculations used are the following:
Created Week: if(row()=max(row()), "Total", to_string(${orders.created_week}))
Total: if(row()=max(row()),sum(pivot_row(${orders.count:total})), null)
Like in the previous method, hide the original timeframe dimension, and you're done! As we're still using the measure, users will still be able to drill into the chart if necessary.
This content is subject to limited support.
Can you help me with the images? I cannot see the image. I have a similar requirement to show total of all the 3 stacked bars.
@keerthiks3107 - Have you got any solution of the problem? I also have the same requirement.