I need some guidance or looking for documentation on how to start working on aggregate indicator reporting, we have registration system for beneficiaries.
Now we need to work on aggregate level data reporting.
I have several questions, how should we configure aggregate level fields, what are the several ways to generate those data etc.
Thanks for the feedback and links to training material.
I have one basic question, when we are creating elements for tracker program - like Tracker entity attribute or Data Elements - How should we configure Aggregation Type, so that it will help us in future for reporting purpose?
I am not sure Aggregation type to be configure for TEA or Data Elements, so configuring None as of now.
Your questions are valid and very important because the initial design of the tracker program with consideration of the final outputs when all the data is aggregated is important for proper analysis.
You’re right. The docs does say:
“Aggregation type” refers to the default aggregation method when combining raw data element values across all events. However, tracker-based indicators are most often calculated through program indicators (see below) which are more flexible and customizable after data have already been captured. So do not worry whether your aggregation type should be COUNT, NONE, or SUM. (source)
But when creating the PI, you might face the Common Challenge 4: Aggregation and Disaggregation. When analyzing the data, are the answers for the questions that will be asked going to be counts, percentages, or averages?
Review the aggregation type, what are we trying to do with this indicator? [We want to [COUNT, AVERAGE, GET PERCENTAGE, MAX, MIN…etc] of.]
[For example,] We want to COUNT the number of cases that were hospitalized during both the initial and continuation phases of treatment. (source)