Calculating % off different categories in a column

[#1]

Hi,

I have one column called Rank. I have values in this columns like "Agree", "Disagree", "NA". I can have one bar chart with no. of occurrence of  "Agree", "Disagree", "NA". I take "Rank" column as dimension and Count(Rank) as measure.

But I want to get % of each  "Agree", "Disagree", "NA" in same manner instead only counts. I can do it in pie chart but I need it on bar graph. Can anybody help please help, I need it urgently. Many thanks

[TKendrick20 · Accepted solution]

Hey, analyzing survey data is my specialty!

Should be as simple as Count([Rank]) / Count(TOTAL [Rank])

This will return a percentage for you. Multiply by 100 if you wish.

[#3]

Thanks, its great. Could you please tell me how can I combine e.g "Disagree" and "NA" and display as one dimension Like "DisagreeAndNA" . Thanks

[TKendrick20]

You could do that in your load script with an IF statement or a CASE statement if you are loading from SQL.

Or as your dimension you could put:

IF(MATCH([Rank],'Disagree','NA'),'Disagree and NA', [Rank])