dhis2-users team mailing list archive

Thread
Date

Event indicator will only SUM in pivot table, not COUNT or AVERAGE

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Jane Greig <jane.greig@xxxxxxxxxxxxxx>
Date: Wed, 2 Aug 2017 11:37:19 +0000
Accept-language: en-GB, en-US
Authentication-results: spf=none (sender IP is ) smtp.mailfrom=jane.greig@xxxxxxxxxxxxxx;
Cc: Theo Krommydakis <theo.krommydakis@xxxxxxxxxxxxxx>, twoca <twoca@xxxxxxxxxxxxxxxx>
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99
Thread-index: AdMLgcOsJzQx/KHURkKnJBWuI4Q9+w==
Thread-topic: Event indicator will only SUM in pivot table, not COUNT or AVERAGE

Dear all

I know there is the new AGE-DOB data element, but it currently doesn't do what I need. Therefore in v2.26 in event capture I have created 3 data elements for age years, age months, age days (all are tracker data elements with aggregation type = average), and a program indicator for a single age result for all patients:

Indicator (E-IPD_001 Age in years, total) = Inpatient admissions.EGEN_008 Age (years) +(Inpatient admissions.EGEN_009 Age (months)/12) + (Inpatient admissions.EGEN_010 Age (days)/365.25)

If I try to use that indicator in pivot tables or data viz, I only ever get a SUM, even when I have changed my option of aggregation type in pivot tables to be COUNT or AVERAGE. If I include the individual data elements, they change as they should. Example images below.
[cid:image006.jpg@01D30B8C.136B1C30]

SUM                                                                                                                      COUNT                                                                                                                 AVERAGE
[cid:image007.jpg@01D30B8C.136B1C30]     [cid:image008.jpg@01D30B8C.136B1C30]         [cid:image009.jpg@01D30B8C.136B1C30]

Is this 1) expected behaviour, 2) something I have configured poorly, or 3) a bug?

Thank you
Jane

________________
Jane Greig, PhD
Operational Epidemiologist MSF-OCA
Manson Unit, MSF-UK




M?decins Sans Fronti?res/Doctors Without Borders (MSF)
Lower Ground Floor, Chancery Exchange, 10 Furnival Street, London EC4A 1AB
Tel: +44 (0)20 7404 6600 | Fax: +44 (0)20 7404 4466

M?decins Sans Fronti?res/Doctors Without Borders (MSF) is an independent international medical humanitarian organisation that delivers emergency aid in more than 60 countries.

Discuss, debate and get the latest news from MSF:
Online<http://www.msf.org.uk/?utm_campaign=msfemails&utm_source=emailfooter&utm_medium=email&utm_content=home> | Facebook<http://www.facebook.com/msf.english> | Instagram<http://instagram.com/doctorswithoutborders/> | Twitter<http://twitter.com/msf_uk> | Youtube<http://www.youtube.com/channel/UCId9tO5LYlJKgNQKEzgjYOg?sub_confirmation=1> | Subscribe to emails<http://www.msf.org.uk/sign-up-for-msf-uk-emails?utm_campaign=msfemails&utm_source=emailfooter&utm_medium=email&utm_content=emailsignup>

Donate to MSF UK<https://secure.msf.org.uk/Donate/MultiLanding.aspx?type=dd&source=7001&country=000>

MSF (UK) is a company limited by guarantee | English Charity Reg No.1026588 | English Registration No. 2853011