See attached. I'm thinking this is a formatting issue but I've lost enough time to figuring it out myself.
I'm trying to write the set analysis for Task_Opened_At is between Visit_FirstViewByDay and Visit_IncidentWindowEnd but nothing has worked for me. The results should be zero so I'm testing with Task_Opened_At <= Visit_FirstViewByDay and >= Visit_IncidentWindowEnd. This should count all the records but I'm getting no results.
This is working! I was thinking I could somehow include this calculation in my load script but I wasn't sure how to get there and this did it for me. Thanks!
In my actual data set I am pulling in 90k+ tasks and not all of them match Visit details. Would changing the join to left join keep only the tasks that match or when I add count_flag in the last load should I filter out tasks that dont have a visit_date?
