Tableau - Both count and Percentage in Measure Values

0
votes

I got a sheet that contain stacked bars of 2 measure values like the picture above(It's not mine but it's similar).

Stacked Bars

My question is, if there is any way to show both count and percentage of each stacked bar. My data looks like picture below.

Data

Thank you in advance!

1
data-visualizationtableau-api

1 Answers

1
votes

While importing data into tableau don't import total column (it is redundant here). By posting your data you have made it clear that you have data reshaping issue. Proceed like this-

Step-1 While importing/connecting to worksheet, click app1 and app2 columns and then pivot them both. screenshot

enter image description here

Rename these fields as per taste. I have re-named these as app name and val respectively.

Step-2 Create a calculated field as

{FIXED [App name]: sum([val])}/{sum([val])}

and build a view like this. (Format calculation1 as percentage)

enter image description here

Good Luck.