Show data based on different criteria

Support - Assistance technique
1

Hi community

How would I build a program indicator (Aggregate type, analytics type, expression, filter) if I want to fetch data based on three conditions, and each data element that make up the program indicator is its program stage?

For example: I want to count beneficiaries who received service A in stage1 and received service B in stage 2 and received service C in stage 3. (Stage1.service=”A”&& Stage2.service=”B”&& Stage3.service=”C”)

I know that * Analytics type helps determine what kind of data we are analyzing. But when it comes to computing PI, the question is what would be the result of:

  • Aggregate Type : Count (here no problem)
  • Analytics Type : Enrollment
  • Expression : event
    VS
  • Aggregate Type : Count (here no problem)
  • Analytics Type : event
  • Expression : enrolment
    VS
  • Aggregate Type : Count (here no problem)
  • Analytics Type :event
  • Expression : event

Looking forward to help.

cc: @brian

1 Like
2

Hi @ferdinandmussavene
Thank you for your patience. It’s great to address the community because this means involving all community members that would like to contribute and help.

This is the keyword that you are tracking TEIs and not events which means the only option here is to choose analytics type enrollment.

Are these events in one program stage or each stage is a program stage?

If each is a program stage on its own, I think you will need to create a PI for each stage and then configure a combined indicator which will sum the result from each PI.

Thanks!

For reference, this topic has been discussed here: The difference between V{enrollment_count}, V{tei_count}, V{event_count}

3

Hi @Gassim,

Thanks for your post. each stage is a program stage. Isn’t it possible to combine all three conditions in just one program indicator without having to create separate PIs?

Thanks