dhis2-devs team mailing list archive
Mailing list archive
Re: [Dhis2-users] Indicator totals count is incorrect
This has been repeated ad nauseam - as you say, most health indicators
should in general be calculated as sum(numerator)/sum(denominator), whether
it's aggregated in the time or in the geographic dimension. That is because
most aggregated data elements used to calculate indicators are counts of
many discrete events.
Yes, we need some alternative processing for
- "number only" indicators (aka "Calculated data elements") and certain
- indicators that include data elements representing "levels" (e.g.
hospital beds, or staff numbers - those can be summed up geographically but
must be averaged over time).
Most of the underlying meta-concepts are in the DHIS already (data types,
aggregation types), but implementing it fully requires quite a bit of
re-engineering analytics - which hopefully will be done for 2.31 :-)
On Tue, 18 Sep 2018 at 19:03, Nayeem Al Mifthah <n.mifthah@xxxxxxxxx> wrote:
> Might be same behavior desires for totals as well.
> Nayeem Al Mifthah
> Kindly ignore typos.
> On Tue, 18 Sep 2018, 22:35 Nayeem Al Mifthah, <n.mifthah@xxxxxxxxx> wrote:
>> 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
>> 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.
>> 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
>>> 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.
>>> 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.
>>>> 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
>>> 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
> 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
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Iridium SatPhone: +8816-315-19119