I'm not sure if this quite got there (shape doesn't look quite right),
but maybe it can give ideas.
All the following scaffolding may not be necessary,
as it sounds like you were almost there.
Maybe the main part is just at the end with the datedding to #1899-12-31#.
I'm not sure if this will be feasible for your true datasource,
but I needed to make a data scaffold which was just:
ScaffoldDay | ScaffoldHour
0 | 0
0 | 1
0 | 24
1 | 0
10 | 24
Then I joined your datasheet to the scaffold
with a calculated field of just 1.
This makes excessive joins, so I needed to make a filter.
First step was to convert the ScaffoldDay and ScaffoldHour into a proper DateTime using:
MAKEDATE(YEAR([Event Start Time]),MONTH([Event Start Time]),DAY([Event Start Time])+[ScaffoldDay]),
Then the filter becomes:
[ScaffoldDateTime]>=DATETRUNC('hour',[Event Start Time])
[ScaffoldDateTime]<=DATETRUNC('hour',[Event End Time])
I made the continuous plot day using:
I custom formatted the date to "dd" and then moved the start point to get rid of the 31 on the axis.
Please see workbook v10.3 and datasource attached in the Forum Thread.