-
1. Re: Creating a 100% stacked bar chart with 2 measure values
Benjamin Greene Aug 9, 2016 6:30 AM (in response to Daniel Santamaria Ots)2 of 2 people found this helpfulMy best guess would be to create two new calculated fields:
SUM([Confirmed Auto])/(SUM([Confirmed Auto)+SUM([Confirmed Imported]))
and
SUM([Confirmed Imported])/(SUM([Confirmed Auto)+SUM([Confirmed Imported]))
Then use these in the Measure Names card instead.
-
2. Re: Creating a 100% stacked bar chart with 2 measure values
khalid norat Aug 9, 2016 6:37 AM (in response to Daniel Santamaria Ots)1 of 1 people found this helpfulYou are trying to show 2 measures as a percentage of the sum of the 2 measures.
This is not achievable via a built in function of tableau.
You will need to create a calculated field total measure --> measure1 + measure 2
then 2 more calculated fields measure 1/ total measure
and measure 2 / total measure
this will give you the percentage values you would like to plot.
If you need further help please share a sample workbook and i can demonstrate the method i described.
-
3. Re: Creating a 100% stacked bar chart with 2 measure values
khalid norat Aug 9, 2016 6:39 AM (in response to Benjamin Greene)That's the correct method Benjamin.
I was just too slow to answer
Keep up the good work.
-
4. Re: Creating a 100% stacked bar chart with 2 measure values
Daniel Santamaria Ots Aug 9, 2016 6:45 AM (in response to Benjamin Greene)Thank you so much Khalid! I'll try it to see how it goes.
Dani
-
5. Re: Creating a 100% stacked bar chart with 2 measure values
Daniel Santamaria Ots Aug 9, 2016 6:46 AM (in response to Benjamin Greene)Thank you Benjamin! It helps a lot.
Dani
-
6. Re: Creating a 100% stacked bar chart with 2 measure values
natun barosh Apr 19, 2018 4:07 PM (in response to khalid norat)hey benjamin,
i used your method and it work fine. i do have one question regarding this method: how do i show the label of the original value (meaning the one i used to create the calculated field)?
thanks,
natun barosh