10 Replies Latest reply: Oct 31, 2017 1:31 PM by Eduardo DImperio RSS

    Set Analysis to get Distinct Field

    Eduardo DImperio

      Hi people,

       

      I have three fields NAME_SYSTEM, OID_GROUP and DATA. I want to count how many NAME_SYSTEM's i have but unfortunately my other fields have more that one value for each NAME_SYSTEM so my count doesn't right.

      I tried this, but not worked:  Count(DISTINCT{1-$<DATA={'Nao Agendado'}>}NAME_SYSTEM)

       

      Input:

       

      set_analysis.JPG

       

      Expected Output:

       

      set_analysis2.JPG