Hi all - I have 2 survey question fields within my dataset, that include 1-10 scores across both columns. I am trying to understand the percentage of customers that gave the same response across both questions, as well as, the % of responses did not rate the same across both questions. I am easily able to calculate the % of people who gave the same 1-10 rating by using the Multi Row Tool where i have
"if Q1 = Q2 then "Yes" else "no" endif"
I am having trouble figuring out what the best tool is to use to understand the % of customers that did not rate the same--
the output needs to be something like this....
the "yes" cells in the table below, is what I currently have.
| | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 1 | yes | | | | | | | | | |
| 2 | | yes | | | | | | | | |
| 3 | | | yes | | | | | | | |
| 4 | | | | yes | | | | | | |
| 5 | | | | | yes | | | | | |
| 6 | | | | | | yes | | | | |
| 7 | | | | | | | yes | | | |
| 8 | | | | | | | | yes | | |
| 9 | | | | | | | | | yes | |
| 10 | | | | | | | | | | yes |
