Specifically trying to match the Start/End times against the EventID's/Dates So that the Bandwidth fill in the TimeBin intervals rather than just the three time slots below. It should range up to i.e 1-24 or in this example 7-23 hours
Only shows the sum of the three. I want it to show over the start to end hour periods/intervals.
I'm open to suggestions. I may not need IntervalMatch
See attached table;
IntervalMatch:
IntervalMatch(hours)
LOAD
StartTimeBin,
EndTimeBin
Resident [MidAtlantic];
Left Join(IntervalMatch)
Load
EventID,
StartTimeBin,
EndTimeBin
Resident [MidAtlantic];