Forum Discussion
shermayne123
3 years agoHelper I
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...
HotChilli
3 years agoCommunity Champion
I suspect that the 'if..then' has been written in the expectation that later comparisons will over-write the positive 'hits' from earlier comparisons (because there are 3 columns in the comparison) but it won't work that way.
I think that the [XXX is Faster and Easier] comparison tests are the only ones that do anything.
So you will have to either re-write this with some logic changes to test all 3 columns in each clause OR
you could maybe split the logic to add 3 conditional columns (1 for each column tested) and then add a further conditional column to test the results of those. That'll make it a bit easier to deal with.