Hello,
i am trying to develop a code to find the count of process where the status is exclusively 'not in scope' and does not have any other status for a particular Unit. The source data is attached.
i tried with this code:
tier_3:
Load
Major category,
unit,
'Tier3' As Tool,
Count(DISTINCT (if([GFC Status]='Not in Scope',Process))) as Process
From sourcedata
Group by Major category,Unit, Process;