I am a new engaged user of DHIS2 and new to DHIS2 community as well. I need some clarification on how expected numbers are computed. I noticed some reporting rates were higher than 100% because the denominator (expected reports) was smaller compared to submitted. Any clarifications?
If I understood your question well, I think
the expected numbers of reports = number of organization units you assigned to the data set during dataset creation and they still assigned before running analytics.
reporting rates is the number of submitted and completed reports (Actual reports) divided by the expected number of reports calculated as percentage, and the result should be <= 100%
A couple of glitches with the reporting rates that might generate results >100% (I don’t know if they’ve been fixed in recent versions of DHIS2, but they were present in older versions):
The denominator is ‘open’ facilities, but closed facilities aren’t filtered from the numerator - so if you close a facility, its reports will still show in the numerator, but it won’t be counted in the denominator, leading to performance of >100%. This can also happen in reverse with new facilities that are opened, artificially lowering the reporting rate - see: [DHIS2-2739] - Jira (although this ticket was closed, I’m not sure the bug was actually fixed).
If you’re using Attribute CatCombos in your aggregate data collection (ie a set of options at the top of the form, which allows you to capture the form different projects, donors etc), then the reporting rate summary can’t handle that - if users have submitted 2 versions of the form for two different projects, it will divide them by just that single form = 2/1 = 200%.
Let us know if either of these might be your problem - if not, it would be good to investigate and report any other issues you’ve found, as reporting rates should never exceed 100%.