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.
DHIS Data Visualiser
DHIS Data Set Reports
Could someone have a look at this.
Hi,
John and I are seeing the same here in Laos - actually it is fine when you select Details, but double when selecting Totals
Knut
On Mon, Mar 2, 2015 at 6:29 PM, Shashank Raghavendra shashanr@thoughtworks.com wrote:
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.
DHIS Data Visualiser
**
**
DHIS Data Set Reports
**
**
Could someone have a look at this.
ThanksShashank RaghavendraQuality Analyst
Skype shashank.raghavendra
Telephone
+91 9632802392
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
Where are we with this?
Megan McGuire
eHealth Unit/OCP Medical Department
Médecins Sans Frontières/Doctors Without Borders
+1.646.369.2695
Skype: megkmcguire
From: Shashank Raghavendra shashanr@thoughtworks.com
To: DHIS 2 Developers list dhis2-devs@lists.launchpad.net,
Cc: twmsf twmsf@thoughtworks.com, Megan McGuire megan.mcguire@newyork.msf.org
Date: 03/02/2015 06:30 AM
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.
DHIS Data Visualiser
**
**
DHIS Data Set Reports
**
**
Could someone have a look at this.
Thanks
Shashank Raghavendra
Quality Analyst
Skype shashank.raghavendra
Telephone
+91 9632802392
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?
Knut
On Mar 9, 2015 3:10 AM, “Megan McGuire” Megan.McGuire@newyork.msf.org wrote:
Where are we with this?
Megan McGuire
eHealth Unit/OCP Medical Department
Médecins Sans Frontières/Doctors Without Borders
+1.646.369.2695
Skype: megkmcguire
![]()
From: Shashank Raghavendra shashanr@thoughtworks.com
To: DHIS 2 Developers list dhis2-devs@lists.launchpad.net,
Cc: twmsf twmsf@thoughtworks.com, Megan McGuire megan.mcguire@newyork.msf.org
Date: 03/02/2015 06:30 AM
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.
DHIS Data Visualiser
**
**DHIS Data Set Reports
**
**Could someone have a look at this.
Thanks
Shashank Raghavendra
Quality Analyst
Skype shashank.raghavendra
Telephone
+91 9632802392
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Hi Shashank,
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.
This query reveals the two option combos:
select distinct dv.categoryoptioncomboid, cocn.categoryoptioncomboname
from datavalue dv
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.
best regards,
Lars
On Mon, Mar 2, 2015 at 12:29 PM, Shashank Raghavendra shashanr@thoughtworks.com wrote:
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.
DHIS Data Visualiser
**
**
DHIS Data Set Reports
**
**
Could someone have a look at this.
ThanksShashank RaghavendraQuality Analyst
Skype shashank.raghavendra
Telephone
+91 9632802392
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut,
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
Regards
Calle
On 9 March 2015 at 07:41, Knut Staring knutst@gmail.com wrote:
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?
Knut
On Mar 9, 2015 3:10 AM, “Megan McGuire” Megan.McGuire@newyork.msf.org wrote:
Where are we with this?
Megan McGuire
eHealth Unit/OCP Medical Department
Médecins Sans Frontières/Doctors Without Borders
+1.646.369.2695
Skype: megkmcguire
From: Shashank Raghavendra shashanr@thoughtworks.com
To: DHIS 2 Developers list dhis2-devs@lists.launchpad.net,
Cc: twmsf twmsf@thoughtworks.com, Megan McGuire megan.mcguire@newyork.msf.org
Date: 03/02/2015 06:30 AM
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.
DHIS Data Visualiser
**
**DHIS Data Set Reports
**
**Could someone have a look at this.
Thanks
Shashank Raghavendra
Quality Analyst
Skype shashank.raghavendra
Telephone
+91 9632802392
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Hi All,
I just noticed this bug in data set reports which shows wrong data totals .
We are using 2.36.3 and the problem exists.