We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.
We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.
Subject: Inconsistency in the values between the data visualiser and the data set reports
Hi All,
We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.
In the Laos case, this turned out to be caused by having TWO “default” categoryoptioncombos. Which begs the question as to how that could have happened - most likely due to a metadata import, perhaps?
Subject: Inconsistency in the values between the data visualiser and the data set reports
Hi All,
We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.
the problem is that you have data for “Uncomplicated vaginal delivery” for 2 category option combinations: “Cases” and “Numbers”.
The data set report will produce the aggregate total for the category combo/category option being used for the data set/section only, in your case “Numbers”. Data visualizer will, for the data element totals, use data from whatever category options exist in the database (basically it ignores the category option combos) when it produces the data element totals.
inner join _categoryoptioncomboname cocn on dv.categoryoptioncomboid=cocn.categoryoptioncomboid
where dataelementid=4781;
5080;"(Cases)"
5090;"(Number)"
So this is expected output. You will have to decide on whether to merge the two option combos, or define the category option to use in analysis explicitly. E.g. in Data Visualizer, if you select “details”, then select “Uncomplicated vaginal delivery (Number)” it shows the same number as data set report.
We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.
Good to see others running into the same problem - I’ve reported this issue weeks ago (and it’s finally been recognised as a bug). you might end up with duplicated catoptioncombos several ways - either because users create them by mistake (no checks done), or else through importing catcombos from another instance.
Hopefully it will be resolved before release of 2.19
In the Laos case, this turned out to be caused by having TWO “default” categoryoptioncombos. Which begs the question as to how that could have happened - most likely due to a metadata import, perhaps?
Subject: Inconsistency in the values between the data visualiser and the data set reports
Hi All,
We are seeing inconsistency in the values between the data visualiser and the data set reports. The values in the data visualiser is exactly double of the values in the data set reports.
For example, in Yemen when we look at “Delivery Room - Deliveries - V1” data set section, for the month of November, data set reports has the value 37 while it is 74 in the data visualiser.