Hi all,
We have a checklist, which is a repeatable stage. We want to calculate a checklist (made up of yes/no questions) percentage for every single event. We would then want to visualize the percentage of every single event in the event report. E.g, If a health provider has had 5 procedure checklists(events) filled about him, we want to view the percentage of each event for each provider. Can you help us to build this kind of indicator?
Formula: Questions answered yes/ divided by the total number of questionsX100
What should have as:
Aggregation type
Analytics type
Expression
Thanks
1 Like
Which dhis2 version is this before we proceed to share thoughts?
To build the desired indicator in DHIS2, you would set the following values for the specific fields:
Aggregation type: For this scenario, you can set the aggregation type as “Average” since you want to calculate the percentage for each individual event and then visualize the average percentage across multiple events.
Analytics type: The analytics type depends on your specific data setup and reporting requirements. If you want to analyze the data over time, you can choose “Event” as the analytics type. If you want to analyze the data based on specific dimensions like organization unit or program stage, you can choose “Tracker” as the analytics type. Select the appropriate option based on your reporting needs.
Expression: The expression should be set to calculate the desired percentage using the provided formula. Assuming you have two data elements: “Questions answered yes” and “Total number of questions,” you can use the following expression:
Expression: (#{Questions answered yes} / #{Total number of questions}) * 100
Replace Questions answered yes
and Total number of questions
with the corresponding data element names or data element IDs in your DHIS2 instance.
By configuring the indicator with these settings, you will be able to calculate the checklist percentage for each event and visualize it in the event report. Adjust the expression and other parameters based on your specific data setup and reporting requirements in DHIS2.
1 Like
Hi @moses_mwale,
The DHIS 2 version is 2.36.12.1
Sorry if I misunderstood your explanation, but regarding this part, yes I want to calculate the percentage for each individual event, but not visualize the average percentage across multiple events. For example, if the percentages of events A, B and C have been 70%, 48% and 83%, then I want to visualize 70, 48 and 83 in the event report, not the average percentage across events A,B and C.
NB: The checklists are configured as repeatable stages.
In the DHIS 2 version above, there are only two analytics types: event and enrollment. There is no tracker analytics type.
Thanks
1 Like
How about if we set the numerator of the indicator to be the count of “yes” responses for the checklist questions in that event and set the denominator of the indicator to be the total count of checklist questions for that event. Can this work so we create the expression?