7 Replies Latest reply: Aug 22, 2012 5:25 PM by haagenfels RSS

    How to calculate total count of a specific value in a field?

      Hi All,

       

      I am trying to calculate the count of a specific value in a field. I would like a table with 'Topic,' and when i pick a specific topic I am able to get a total count from a Yes/No field 'Validation.'  For example: Topic = documents and the validation has 24 docments have YES and 6 NO.  How can I get it to show the total YES/NO count based on criteria I pick?  I currently have my Dimension = Topic, Expression = count(distinct(validation).

       

      Thank you for your help.