Am wondering if it is possible to use d2:daysBetween (or weeks, years, etc) to find the difference between two event dates in the same program (but belonging to different program stages). I know you can use the program stage name/id in the filter, but in this case can I need to specify the event dates so it knows which dates to find the difference between. Can I prefix these dates somehow?
In this use case I have a malaria program where cases are identified (stage 1). In stage 2 an investigation is performed, ideally this should be done within 2 days of case identification. Essentially am looking for a count of these events that meet this criteria.
Am wondering if it is possible to use d2:daysBetween (or weeks, years, etc) to find the difference between two event dates in the same program (but belonging to different program stages). I know you can use the program stage name/id in the filter, but in this case can I need to specify the event dates so it knows which dates to find the difference between. Can I prefix these dates somehow?
In this use case I have a malaria program where cases are identified (stage 1). In stage 2 an investigation is performed, ideally this should be done within 2 days of case identification. Essentially am looking for a count of these events that meet this criteria.