I have an issue where I have two dates, a start date and an end date. I need to be able to count active policies between these two dates. My current implementation is count(Distinct {<Started = {'$>=Ended'}>} PolicyNumber) with Started as my dimension, but I am not having ended policies properly removed from the data. Any suggestions on how to properly account for when a policy ends?
