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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp