I have a fact table with columns that show the Purchase Start Date & Time of a vehicle entering a car park and another column that shows the Purchase End Date & Time. I have also split these out into Start Date, Start Time, End Date and End Time.
I need to produce a visual that shows the total occupancy over a day, week, month etc, and so I also have a Date and Time dimension table.
I’ve tried bringing these values into a line chart, but with no success, so I would imagine that I need to create a measure of some kind. Any ideas?
I’ve attached some sample data covering two days.
Sample Data.xlsx (24.1 KB)