Hello all,
I need your help. We’re building our database on DHIS 2, and for testing purposes, I’ve created a simple Program/Attribute containing the following tracked entity attributes:
Individual id
Name
Gender
Date of birth
The gender is connected to an option set having 2 options: male
and female
.
I called the program Registration
and created a tracker program contain all the above tracked entity attributes.
Then, I created an indicator that represents:
number of females as numerator
to the total of rows as denominator
Multiplied by the factor that I’ve called it: per cent with a value of 100 to get a percentage.
The process was by creating a program indicator called numeratorExp
. The program indicator details was the following:
- Program:
Registration
- Name:
numeratorExp
- Short Name:
numeratorExp
- Aggregation type:
Count
- Analytics type:
Enrollement
For the expression, I’ve added the attribute gender
, and for the edit filter section I typed:
#{ArNi9SFhStX.EYDk2Ob8Ptt}== 'female'
where the #{ArNi9SFhStX.EYDk2Ob8Ptt}
is the generated attribute name presentation by DHIS 2.
For the denominator: We’ve created the same steps, but without an edit filter
but the edit expression
was the individual
id so it can count all the existing ids.
Then we went to the indicator and I specified the num
and denom
.
To test it, we’ve added few rows and with gender as male or females, and at the pivot table, we specified the organization level, periods as today’s and indicator.
No data nor preview was shown in the pivot table interface. We tried to see the data in report section but we didn’t see any data.