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.

···

ThanksShashank RaghavendraQuality Analyst
Skype shashank.raghavendra

Telephone
+91 9632802392

ThoughtWorks

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

ThoughtWorks


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

http://dhis2.org

Where are we with this?

Megan McGuire

eHealth Unit/OCP Medical Department

Médecins Sans Frontières/Doctors Without Borders

megan.mcguire@newyork.msf.org

+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

megan.mcguire@newyork.msf.org

+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

ThoughtWorks


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

megan.mcguire@newyork.msf.org

+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