9 Replies Latest reply: Dec 15, 2015 2:24 PM by Stefan Wühl RSS

    Count total of 1s, 2s, 3s, 4s, and 5s in single expression

    Tyler Gregory



      I am trying to count survey results to display them in a pie chart.


      I want to count the number of 1s, 2s, 3s, 4s, and 5s in the field [Type of PII] in one expression.


      I am able to do it in multiple expressions but this will not allow me to show the values on the pie chart. 


      Please let me know if you know the syntax to make this work in 1 expression.

      Thank you!