avniproject / calcutta-kids

0 stars 0 forks source link

[Support CK ] Fix a report #58

Closed nupoorkhandelwal closed 1 year ago

nupoorkhandelwal commented 1 year ago

Support ticket - https://avni.freshdesk.com/a/tickets/2583

This report is showing data only post 2020 -https://reporting.avniproject.org/question/323-monthly-report-immunizations-eligible-and-completed

Need to investigate the reason and fix it.

Analysis: Refer the ticket.

Before query change:Screenshot 2023-04-28 at 2.17.56 PM.png

After changing to include non-active individuals(individuals who dont have encounters in last 5 months): Screenshot 2023-04-28 at 2.18.40 PM.png

After query change to include individuals exited from program: Screenshot 2023-04-28 at 2.20.28 PM.png

One way to test: can check the individual ids displaying in report - before 2020 - will either be exited from program or will not have recent encounters in past 5 months