Get count of DataElement of type yes/no

Support - Assistance technique
,
1

Using indicators or some other means, is it possible to get count of yes and count of no for aggregate DataElement of type yes/no?

2

Hi Zubair,

You can try with the following SQL View:
https://play.dhis2.org/2.34.1/dhis-web-maintenance/index.html#/sqlViews/obCuOwElLvR

SELECT de.name as dataElement,
p.iso as period,
ou.name as orgUnit,
dv.value as value,
count (*) as total
FROM datavalue dv 
INNER  JOIN dataelement de on dv.dataelementid = de.dataelementid 
INNER JOIN _periodstructure p on dv.periodid = p.periodid
INNER JOIN organisationunit ou on dv.sourceid = ou.organisationunitid
WHERE de.valueType = 'BOOLEAN'
group by ou.name, p.iso, de.name, dv.value
;

It groups result per DE, OU and Period.

3

Hi… Were you able to find a solution for the same?

4

Also @stratosilva Do you have a solution that includes the system itself doing a count of data elements of particular value e.g. yes/no OR other option sets OR data element isNull/isNotNull

Also do you know how the count aggregation type for aggregate data values works?

5

Hi Please, Did you found the answer?

6

Hi @eviesn @lillian1n2

Why not create indicators for this case? Would it work if you’re using an indicator to count the yes / no?

1 Like