How to calculate the number of orgUnits that have a data element value> 0?

Hi all,

how to calculate the number of org units that have a data element value> 0?

Hi @taufiqhs,

If you are doing this in tracker then you can use a program indicator. If you are doing this in aggregate then you will need to make a predictor. Please refer to the docs on predictors and this post on how to make a predictor:

1 Like

Hi @Scott,

Thanks for this, will practice using predictor.

Hi @taufiqhs,

And if you’re using Events/tracker I think you can perhaps also test out the program indicator with the expression org_unit_count (The count of organisation units (useful in combination with filters). Aggregation type for the program indicator must be COUNT.). Let us know if that also meets your usecase!

Best,
Karoline

1 Like

Hi Karoline.

Yes. That is the solution for the event/tracker. And for aggregate data element need to test again