3 Replies Latest reply on Jun 13, 2016 11:36 AM by Christina Gremore

    Calculated Field for Surveys - Combine/Label Based on # of Responses

    Nicholas Kamenos

      Hi Everyone,

       

      I'm looking for help creating a calculated field (or feel free to suggest other ways) to combine survey numbers and label them in a certain way based on the number of responses in a specific category.

       

      Here's the scenario:

       

      When I create a bar chart it comes out like this:

           White - 100 responses

          Black/African American - 50 responses

           American Indian/Alaskan Native American - 50 responses

          Asian - 5 responses

           Native Hawaiin/Pacific Islander - 5 responses

           Hispanic/Latino - 5 responses

       

      Here is what I want:

           White - 100 responses

          Black/African American - 50 responses

           American Indian/Alaskan Native American - 50 responses

          Other - 15 responses

       

      I'm also open to other ways to combine survey responses if it is required to be suppressed (ex: if there are less than 10 responses, do not count it.)

       

      Thank you!