Include only completed events in pivot table

(Pamod Amarakoon) #1

Hi @Markus trying to use this feature in 2.30 for program indicators in pivot table. Just wondering when applied in pivot table for above context, it outputs enrolments that are complete or whether it calculates for all events that are completed within an enrolment irrespective of status of enrolment?

Thank you.

Question on completed events field in pivot table page
(Markus Bekken) #2

Hi @Pamod,
Which aggreagation type, expression and filter are you using in the indicator?


(Pamod Amarakoon) #3

Hi @Markus,

Aggregate type: count, Analytics type: enrollment, expression: TEI count, using a filter which has data elements from 4 stages