3 Replies Latest reply on Oct 2, 2017 7:13 AM by Chuck Collins

    Count for Number of Time Answer Choice is Selected

    Chuck Collins

      Hi All:

       

      This for an identity question on a survey where the respondants could choose any combination of sexual orientations. It's a dataset that I inherited and it's pretty messy, but they are sorted by responseID.

       

      Responses are as below, what I want to do is count the number of times that someone selected bisexual, asexual, etc.

       

      I started with else if series but that excludes respondents once the choice is processed. (see below)

       

      Thoughts on the best way to accomplish this count?

       

       

      Calculated Field:

       

      IF CONTAINS([Q7],"Heterosexual") THEN "Heterosexual"

          ELSEIF CONTAINS([Q7], "Bisexual") THEN "Bisexual"

          ELSEIF CONTAINS([Q7], "Gay") THEN "Homosexual / Gay - Male Partners"

          ELSEIF CONTAINS([Q7], "Lesbian") THEN "Homosexual / Lesbian - Female Partners"

          ELSEIF CONTAINS([Q7], "Asexual") THEN "Asexual"

          ELSEIF CONTAINS([Q7], "Pansexual") THEN "Pansexual"

          ELSEIF CONTAINS([Q7], "Questioning") THEN "Questioning or Unsure"

          ELSEIF CONTAINS([Q7], "Other") THEN "Other"

      END

       

       

      Response Combinations of Data from Select All that Apply Question: