Age Group

spalavi · 4 June 2019 07:29

I am new to DHIS2 and I am finding it challenging to design a pivot table with multiple categories, eg; a pivot table that has age-groups per gender in an orgunit plus other indicators? Data was collected using a Tracker Program. A step by step approach will be highly appreciated.

prosper · 5 June 2019 05:22

Hi @spalavi

You can use program indicators and create for each age group so they can be used in pivot tables and visualizer.

Or else you can use legends and apply them on the attribute age then use it in events.

Regards

spalavi · 6 June 2019 04:46

Hi Prosper,

Thanks for reply and please could you help me creating this table attached in DHIS2.

Much appreciate your help.

Thanks,
Siosaia

prosper · 6 June 2019 15:04

Dear @spalavi

With legends you can achieve this

and this

spalavi · 7 June 2019 01:01

Prosper,

Happy to hear from you and appreciate all your help. Please take note I am new to this and I am trying to figure out how to retrieved aggregate values data on event report. Refer to the attachment below there is no data

Also let me know how to setup range set.

Thanks.

prosper · 7 June 2019 05:46

Hi @spalavi

Sorry for the shortcuts,

To create legends; what is referred as range in events reports; Go to maintenance>> All>> Legends
Add a legend according to your ranges
https://play.dhis2.org/2.32.0/dhis-web-maintenance/index.html#/list/otherSection/legendSet

After creating the legend, then assign the legend to your age attribute (tracker) or data element(events)
https://play.dhis2.org/2.32.0/dhis-web-maintenance/index.html#/edit/dataElementSection/dataElement/qrur9Dvnyt5

Note you can assign more than one legend allowing you to switch in between different age ranges

Regards and hope this helps

Channara · 20 May 2021 15:44

Hi @prosper ,
if apply on data element, it is working fine. but it doesn’t work with tracker attribute.
do you know how to apply legend age group to tracker attribute in event report?

thank you
channara

feh · 2 December 2021 15:07

Hi Prosper

Thank you for this. In a case where my attribute is of type date, like date of birth, Can i still use legends?

I am currently pulling that data through program indicators, but will like to use ranges/legends.

Thanks

Gassim · 6 December 2021 20:49

Hi @feh ,
Welcome to the community!

You are using the Events app, isn’t it? Please what DHIS2 version are you using? I think you can definitely add the DoB as long as you can see it in the program stage attributes. See example from play: