6 Replies Latest reply: Oct 20, 2017 1:03 PM by Sunny Talwar RSS

    Get total count of responses to a question for each response

    Michael Andrews

      So I have data that is essentially a test. A test has questions, and each question may have multiple responses. I need to do a calculation on the response level, but also work with the total number of responses for that question. Let's assume my data looks like so

       

      Question 1 had 15 total responses

       

      Response Name# of responses% correct
      Ans11010 / 15
      Ans244 / 15
      Ans311 / 15

       

      Basically what I need to do is figure out a way in the function for % correct to get that 15 number each time to work with. Any idea on how I do that. I've attached a screen shot of my actual data to help portray what I'm trying to do.