7 Replies Latest reply on Feb 8, 2019 11:50 AM by Michel Caissie

    different filters in separate colums

    zahra.fd

      Hello,

       

      I have a data set which has 3 columns. One of is district (values:1,2,3,4,5), the other column in called matched (values: matched, unmatched) and the last column is the percentage (values:0-100)

      I need to create a table where the first column is the district number, the second number is the total people in the district (e.g., 1=30, 2=40, 3=55, 4=66), the third column is the total number of people who have been matched and the last column is the total number of people who have been matched and are above 70%.

       

      The problem is once I apply the filter to get the third column, it wants to apply them to all other columns, that is it changes the values in the second column which was the total.

       

      I have also tried to create a calculated field like the following :

      if [matched] == 'matched' THEN COUNT([district])

      END

       

      and it gives me the following error:

      cannot mix aggregate and non-aggregate comparisons or results in 'if' statement

       

      Are there any other ways where I can apply these filters on each column individually?

       

      Thank you in advance!