tableau - How do I display the total percentage and count together as a stacked bar chart without formatting all data to percentage values? -
i asked this question (and this question) recently, , though both have solutions, left new dilemma because each solution works on independent level (i.e. 1 solution won't work if other solution in place).
the problem this: in tableau, discovered opting display data percentage of total row value analysis > percentage of > row
, resulted in count
value being displayed number between 0 , 1 (i.e. percentage format, because of aforementioned percentage-only setting).
is there way achieve 100.00% stacked bar shows both percentage , count, , isn't formatted display data percentage of row total?
the screenshot shows happens when both solutions in place. original screenshots available within body of each of previous questions.
note: feel right way go might normalise data (bringing values scale between 0 , 1), being new tableau, not sure how achieved. if correct, appreciate walkthrough.
right click on second sum({number of records]) pill on label shelf, , clear table calc. edit label if needed
| great, used advice , adjusted label values, , working - thank you! – musthedataguy jul 28 @ 12:14 |