dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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@xxxxxxxxxxxxxxxx> 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.
>
> Thanks*Shashank Raghavendra**Quality Analyst*
> Skype             shashank.raghavendra
> Telephone+91 9632802392
>
> [image: ThoughtWorks] <http://www.thoughtworks.com/>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>