This content has been marked as final. Show 2 replies
In my dataset, I have three rows. Test ID, Test Question, Test Response. Each Test Question is answered as either Yes or No. Each Test ID consists of the same three questions.
What I'd like to do is count the number of times that the test results are as follows:
|Yes, Yes, Yes|
|Yes, Yes, No|
|Yes, No, No|
|Yes, No, Yes|
|No, No, No|
|No, Yes, Yes|
|No, No, Yes|
|No, Yes, No|
I'm attaching a sample dataset for reference.
I suspect that pivoting the data to get all three test scores in one row would be the best solution, but this is not an option as this is a direct feed from the source system.
Does anyone have any suggestions?
Thanks in advance,