Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Expected Output:
Hi Stefan!
More or less, this Count(DISTINCT{1-$<DATA={'Nao Agendado'}>}NAME_SYSTEM) and this Count(DISTINCT {$<DATA -={'Nao Agendado'} >}NAME_SYSTEM) return the same result. The diference was create a new field only with two states Agendado and Nao Agendado.
But thank you for your help