1. Column Startdate (datetime) and Column Endate (datetime).
2. Column CustomerName
The duration between StartDate and EndDate could be many hours, and cross days.
I want a table/graph showing total unique customer count per hour for the last 24 hrs, inlcuding the hours between StartDate and Endate where there is no unique record. So for a record where StartDate is 27/06/2019 2200 to 28/06/2019 0100 i want a value of 1 for 2200, 2300, 0000, and 0100. Obviously cumulative if more records for other customers span this period.
The previous measure was OK, however where the dates crossed days, it broke down as it only grouped by hour, and did not account for date. It aslo did not filter the last 24hrs.