I am trying to build program indicators from event program, but some in-built variables are missing.
Below is the capture screen of the event program. In it we capture the age, gender, and test result.
Gender (male, female, and test result (positive, negative, indeterminate) are dropdown.
One of the Program indicators I want to build:
Sum of all males whose age is greater than 10
Aggreagte type: Sum
Analytics type: event
Expresssion: missing variuables
Filter gender== ”male” && age>10
NB: event count variable is missing if the aggregate is SUM. It shows if the aggregate type is COUNT.. Am I confusing the function of each variable?