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

[taufiqhs (Taufiq Sitompul)]

Hi all,

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

[Scott (Scott Russpatrick)]

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:

Configuring predictors - Disease surveillance

Hi All, Am trying to configure predictors in DHIS2 version 2.29, I have successfully created the data elements and used them while configuring the predictors. A disease like ebola has a threshold of 1(one) positive case, so I put 1 (one) under my generator for the Ebola predictor. I didnt use any formular for this. The challenge is that when I go to pivot tables and generate a report with the Ebola thresholds, no data shows up. I expected to see 1(one). Could there be something I missed durin…

[taufiqhs (Taufiq Sitompul)]

Hi @Scott,

Thanks for this, will practice using predictor.

[Karoline (Karoline Tufte Lien)]

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

[taufiqhs (Taufiq Sitompul)]

Hi Karoline.

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

[lillian1n2 (Lillian N.)]

@taufiqhs How do you test for aggregate data element?