dhis2-users team mailing list archive

[Nayeem Al Mifthah <n.mifthah@xxxxxxxxx>]

Hi Lars and others
I have commented on an old issue DHIS2-575 about the desired behaviour ...

I think expected behavior should calculate the element aggregation as per
aggregation type of that perticular data elements first and later calculate
the indicator. Example:

If number of patient visited OPD in January is 200 and number of admission
in January is 40. In that case, comparison of admission to OPD is 20%.

And in February, number of OPD visit in February is 400 and admission is
200. % of admission to OPD in February will be 50%.



If I want to see the same indicator in January+February, it is showing
liniar average of two months indicator like (20+50)/2= 35%

It should show, (40+200)/(200+400)=30%

I think it should aggregate the element according to aggregation type of
that element at first and then calculate indicator.


Regards,
Nayeem Al Mifthah
Kindly ignore typos.


On Tue, 18 Sep 2018, 22:14 Lars Helge Øverland, <lars@xxxxxxxxx> wrote:

> Hi Gourav,
>
> thanks and, perhaps surprisingly, this is expected behavior as of now.
> Indicators are often percentages, and it does not make sense to summarize a
> lot percentages across different indicators; it makes more sense to average
> them.
>
> That said, sometimes indicators represents plain sums of data elements (no
> denominator, or denominator = 1), so we are working on some refinements
> here which we will backport.
>
> best,
>
> Lars
>
>
> On Tue, 18 Sep 2018 at 08:09, gourav sachdeva <gouravsachdeva95@xxxxxxxxx>
> wrote:
>
>> Hello Team,
>>
>> I'm facing an issue in a pivot table, version 2.28 while calculating the
>> total of indicators.
>>
>> Whenever I try to generate the pivot report with indicators it shows the
>> average instead of the sum in the total section. I checked, the same issue
>> has been created on Jira and the status is resolved but I am still facing
>> the above mentioned.
>>
>> https://jira.dhis2.org/browse/DHIS2-3350
>>
>> Version: 2.28
>> Build Revision: 6657e9d
>> Build Date: 2018-09-17 03:20
>>
>> The screenshot is enclosed for the reference with the mail.
>> Looking forward to your response.
>>
>> --
>> *Thanks & Regards,*
>>
>> *Gourav Sachdeva*
>> _______________________________________________
>> 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
>>
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> lars@xxxxxxxxx
> https://www.dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>