Forum Discussion
Conditional Column - Survey Ratings
Hi, I'm trying to create a viz to show the percentages of survey ratings for "Strongly Agree" and "Agree" for 3 survey questions using a clustered bar chart. However I noticed that the percentage...
i'm confused of your calculation logic.
as your formula, these three columns have different priority. so when [XXX is Faster and Easier] is "Disagree", it will be classified to "Others".
Hi wdx223_Daniel,
The 3 questions have equal priority. As per my reply to HotChilli just now, the way to get the result I want is not to reclassify the responses(add conditional columns) before I unpivot them. I should have unpivot the 3 question columns then add the conditional column to reclassify the responses accordingly. Hope that clarifies and thanks for looking into my problem.