To make a program indicator

[udakaya (udayanga yapabandara)]

In event reports I have a data element called “multiplicity”.

The data element “multiplicity” there are option 1, 2, 3, 4, 5 and 6.

For example
if mulitiplicity is 1 in two events.
if multiplicity is 2 in in two events.
If multiplicity is 3 in three events.

The total count would be 1 + 1 + 2 + 2 + 3 + 3 + 3 = 15

The total events would be 7 .

Is it possible to make a program indcator to count the above ?

Please specify the program indicator “expression” & “filter” for the “total count” & the “total event”.

[ayman.tuffaha]

Hi @udakaya,

Let’s start with the second part of your question which is about calculating total events (7).
You can follow the below configuration from Program Indicator:

Then I recommend using the Data visualizer App instead of the event’s report as indicated below:

Regarding the first part of your question which is related to calculating the total count of option values in different events, I do not think this is possible from the configuration of the program indicator side.

I think it’s similar to the below issue which was raised before could you please check and confirm if it’s the same issue as what you are experiencing?

How to get the count of events having value for a particular data element?

We are trying to sync event data to DHIS using an automated program and we want to ensure that the data is getting synced correctly. We would like to use some queries in the DHIS db to make sure that the counts of events synced are matching with the data we have. Currently, we are checking the programstageinstance table for this. One example query we are using to get the count of all events in HTS program stage is as follows : select count(*) from programstageinstance pi inner join programstage…

[Caroline (Caroline Holen)]

Hi @udakaya

To get the total count from the DE with optionset, make sure the optionset is aggregated with positive or zero integer.
The DE in particular should be SUM in aggregation type.

Create a program indicator for event like in the picture below:

Add the data element just like this in expression

Save, and make sure to run analytics.

Open the event report and add the information you are interested in and update the table:

In my example, I have a TEI called: Hello, with two events in one stage. In the first event I entered 4, and the last one I entered 5. Now you can se the last column is the program indicator. 4+5 = 9
In TEI: hehi I entered 6 in the first event and 3 in the last one: 3+6 = 9

For the event count, Ayman has described this for you, but if you only want to filter by events that has a particular data element entered, you need to filter by that data element…

Caroline