Aggregating weekly reporting rate to monthly

Support - Assistance technique
1

Hi,

I have a question about how the monthly reporting rate figures for weekly datasets are aggregated. I’m working on a dashboard which will have the reporting rates for each week in a month and then the monthly average. This looked fine in June 2025 but in July 2025 the monthly average was higher than it should be. When I looked at the actual and expected reports for the monthly value the actual reports were higher than the expected reports (I don’t think this should be possible).

With some more digging it looks like the Expected reports for this dataset includes all weeks where the Monday was in July (4 weeks), and the Actual reports includes all weeks where the Thursday was in July (5 weeks). So the numerator includes more weeks than the denominator, making the percentage for the monthly average wrong. I think the specific days of the week used may be because our weekly collection starts on a Monday and ends on a Thursday.

Does anyone know if I’m right about the monthly reporting rate including different numbers of weeks in the numerator and denominators if aggregated from weekly data, and if so if there’s a workaround to make my own average of four weeks of reporting rates? I tried making an indicator but when I did a periodOffset with reporting rates/actual reports/expected reports it would ignore the periodOffset.

2

Hello @cbyers

We encountered a similar “issue” in our DHIS2, but it was not related to the reporting rate period. The problem occurred because the dataset was removed from certain organisation units after those units had already submitted their forms. For example, if 10 organisation units submit their forms and then the dataset is removed from 2 of them, the numerator (10) will be greater than the denominator(8).

@SamuelJohnson highligted, in the following topic, some other reasons that might cause this issue Completeness : Actual Reports > Expected Reports

Regards;

1 Like
3

Hi Mamadou,

Thanks for sharing that topic. I’ve had a look and we’ve not got a Category combination on the dataset. I think for our issue its likely more date related than removing organisations because it occurs in every district we have but only on specific months - for 2025 it’s only happened in May and July so far.