Hi everyone,
I’m trying to generate a defaulter list from the tracking data of patients who have missed events.
Case :
Program named : Family Planning
Event Name : Depo,
Event Date : 2025-05-02
Deadline / Next visit date : 2025-08-02 (stored as a data element)
list all the patients who missed the visit date
Thanks in advance!
Hi @rcpoudel
Thank you for your patience! How have you approached this challenge? I wonder if you are aware of the ‘overdue’ filter in the supported versions?
As mentioned in this Jira ticket (Jira), you can filter by overdue:
Thanks!
Here’s the ticket explaining how to use the overdue: Jira
Thank you for the response,
I check the options, this is available in the pivot table, which is aggregate(count format).
I want the list of patients with the overdue (from line listing)
Hi @rcpoudel
You’re absolutely right. I tested again and wasn’t able to find the ‘overdue’ status filter option in the interface nor in the Line Listing app. I’m triaging this issue to the team to see what option is there.
Thank you!
Hi @rcpoudel , hope youre well 
As you can see overdue in pivot tables, I’m assuming you are > v2.39? This is when scheduled events started to beexported to Analytics.
There is no filter for OVERDUE in Line Listing, however you can filter for SCHEDULED events.
A program indicator would allow you to create a value for the days between the scheduled date and the current date. You can then filter based on that value to distinguish between “overdue” and future scheduled events. Or just a value of 1 if the scheduled date is before the current date.. up to you.
Test on play dev
In the value field for the PI SCHEDULED EVENT OVERDUE DAYS
d2:daysBetween(V{scheduled_date},V{current_date})
Filter: d2:hasValue(V{scheduled_date})
Aggregation type: custom
No analytics period boundaries
Hope this helps!
Thank you @brian ,
I implemented and tested the suggested approach in our health facility ecosystem.
Thank you, it worked
