Different data values on visualizer than data entry fields

Hi. I’m having issues with contradicting values on my DHIS2 instance. The values are input in data entry and some indicators filled as well. However, when I pull the report on data visualizer, the values are different by different margins. I need to correct this, it presents issues of accuracy with my end users.

In the screenshot above, the indicators being pointed to are the same. But the values are different.

This is happening with a few data values but the screenshot above is an example of what is going on.

DHIS2 Version: 2.37.7.1

Hi @lillian1n2

Please try to run the analytics tables export and then clear the browser cache.

After I’ve done this and there has been no change in the values displayed?

I’d not know why this contradiction but we need to make sure there’s no error first.

Please check again in a new/different browser/profile, and if it’s still the same, would you please check the Catalina.out log to make sure the tables analytics export runs successfully?

Please share the Catalina.out log (without the sensitive info).

Thank you!

Yes it runs successfully. The log file reads a lot INFO level messages. A few ERROR messages but nothing significant I can pick out thus far. Is there anything particular I am looking for with the files?

Catalina.out when performing run analytics.pdf (287.5 KB)

Hi @lillian1n2 ,
I noticed in the Pivot table you have two rounds selected, but in the data entry app, you are only looking at Round 1. This could account for the differences in values which you are seeing. Please ensure that the parameters which you have selected in the pivot tables match exactly those in the data entry app.

There can be some slight variation in the values seen in the pivot tables and data entry app, due to rounding issues, but normally,these should be very small (one or two).

Best regards,
Jason

1 Like

I highly doubt that is the issue because the category combinations displayed in the screenshot match for data entry and visualizer.

I’ve selected data input in Round 1, Larger Round.

There was no data input in Round 2, so if I scrolled down the table to Round 2, it would be evident. Also I wanted to be clear on the same, which is why I selected both Larger Round and Smaller Round for display.

1 Like

Thanks @lillian1n2! :slight_smile:

I wonder why you’re getting this WARN message?

 * WARN 2022-07-22T18:25:51,768 Ignoring category combo, not valid: {"class":"class
org.hisp.dhis.category.CategoryCombo", "id":"3045", "uid":"gkORyztRORi", "code":"null",
"name":"Deworming Round (Specific)", "created":"2021-04-21 13:49:16.07", "lastUpdated":"2021-08-27
10:49:25.714" } (CategoryOptionComboNameResourceTable.java [taskScheduler-10])

Could this message be the reason why it’s not updating?

@lillian, just making sure you didn’t choose ‘skip’ anything during the analytics tables export?

No I didn’t select any of the options. The other place I see the category combo settings are here:

Respecting category combos is important to the output to my other visualizations.

1 Like