I am using Intervalmatch to assign the time field a time bucket, ex. 13:04:59 -> 1 - 2 pm
However I am facing a situation where the time value matching the End field are not being properly mapped to a time bucket,i.e. 08:59:59 -> Null() whereas the time bucket must be 8 - 9 am. Can anyone please help me solve this issue?
These are probably caused by values that are either slightly more* than (for example) 8:59:59 and therefore fall into the 1 second gap between 98:59:59 and 09:00:00. You could reduce the size of the gaps to a much smaller value:
maketime(RecNo()-1,0,0) as Start,
Time(maketime(RecNo() - 1, 0, 0) - 1E-9) as End,
* this could be due to very small rounding errors caused by the date/time calculations.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein