Pivot Table Not Displaying All Facilities with Completed Data

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Sarah123_1

Welcome to the DHIS2 Community of Practice! To begin with, may I ask what is the version of the DHIS2 instance you are using? And was there a recent update/upgrade or any metadata configuration? Is this the first time a dataset report generated or was it successful on previous attempts and now it is missing some OUs?

@Sarah123_1

Data entry appears to be complete for all facilities as confirmed through both the reports module and on the entry page however, the pivot output is not displaying all the facilities that have submitted data. For instance, out of 15 facilities that have entered data, the pivot output may only show 10.

Before generating the report, please try the following:

• Data Administration app > clear application cache, reload apps
• Data Administration app > Analytics tables > Export analytics tables

When you run the analytics tables, do you see any errors in the UI log or in the Catalina.out log?

Could this be a metadata configuration issue, please check this thread: Reporting rates not working in 2.33 - #10 by Scott

If the solution in the thread I shared isn’t working, please check if there’s a metadata mismatch in this thread: Data importing issues in DHIS2 - #4 by rithvik

I hope these help. In order to understand what the issue is and debug, please respond to the questions above and provide more details after checking the above possible solutions.

Thank you!