Count number of occurrences of each "phase" per day
I want to be able to say for each particular day of the year how many instances of a propery phase is open. I have a table of property ID's that gives which phases the property has been through over time. For example: Using the st_date & end_date I want to be able to show, for instance, on the 30/06/2022 how many properties were in each phase. There are about 30 phases across the business so on the 30/06/2022 I might have: 3 properties in "awaiting work book" 7 properties in " Asbestos inspection" 4 properties in "TORT" I'd expect to see about 150 properties spread over different phases. My problem comes from "on this date" as I only have the start date and end date to work from. I then also need to be able to show for this date "this" many properties were in each of these phases. This is the kind of view I'm trying to get to but for this I'm using the start date on the x axis not the actual count: Thank you in advace for any help, Dan
