2 Replies Latest reply on Apr 25, 2018 6:18 AM by bill.merlavage

    Grouping test results by response combinations

    bill.merlavage

      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,

      Bill