13 Replies Latest reply: Sep 8, 2016 4:03 AM by anya K. RSS

    Count distinct?

    Madeleine Josefsson

      I have the following data and as can be seen there is one row for each question, each of these rows have the same (assignment)number.

      How can I count how many different (assignment)numbers I have? Right now when I count I get 13 times as many as I would like as the (assignment) number appears 13 times for each questionaire.

       

      Thanks!