I have a field named "Projects" Count(projects) = 10
The field Projects contains double values so:
When I type: Count(distinct(projects)) it says: 5 (correct number)
Each project has one (or multiple) status. Now we have a second field named ''statusProjects''.
When a project is on hold, "statusproject" is set to: "on hold".
I want to make a KPI where all on hold projects are counted over the distinct projects
Example:
Depot 5 had 10 NOT unique projects. When I use the statement: Count(distinct(projects)) and I select depot 5, it show 5. So: Depot 5 has 5 Unique projects.
Question: Of these 5 unique projects from depot 5, how many are ''on hold"
Can you please help me with this statement. Thanks 🙂
