Aggregate data discrepancy - Monthly

[dmnscar (Damien)]

Hi all,
In the Pivot Table app (DHIS2 v2.30), we found a bug (maybe) where when viewing data, the January data is different when selecting either ‘Last 12 months’ & ‘Months this year’. The correct value looks to be January in the ‘Last 12 months’ option i.e. the total from 2019w01 - w05.
It looks like for ‘Months this year’, January does not have the 2019w01 data whereas it does in ‘Last 12 months’.
The data is entered weekly.
Attached is some more info/data test - Monthly data issue.xlsx (20.3 KB)

Has anyone faced this before, or have any suggestions to why this is occurring?

[dmnscar (Damien)]

Looks like this is the same issue as the below, albeit in a different Period setting…

Data analysis: difference between last month and last three months

This is done @Scott under DHIS2-5990. I have tagged @Jaime_Bosque as the issue owner. Jaime - Please visit and add more info to the issue for the fix to be well addressed. the team may have some questions for you too. Best, James.