Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
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])