one solution might be:
tabEvents: LOAD *, Interval(Floor(eventTimestamp-WeekStart(eventTimestamp),'00:01'),'d hh:mm') as eventTime; LOAD RecNo() as eventID, Timestamp(Now()-Rand()*1000) as eventTimestamp AutoGenerate 1000; tabEventTime: LOAD Distinct eventTime, IterNo() as MinutesOfTimeslot, Ceil(eventTime*1440/IterNo()) as slot_nr, Interval(Floor(eventTime,IterNo()/1440),'d hh:mm') as slot_time Resident tabEvents While IterNo() <= 1440;
hope this helps
I am working with a free desktop version. Therefor i cannot read your example.
So i first tried to understand the code. After that i implemented, based on your example a solution. This works, but i saw some results i don't really understand in the moment, and i have to look for. It seems, there are some problems with the format of my event-timestamp and the functions ceil and floor returns values i cannot comprehend.
Furthermore i recognized, that my solution works, but is very slow.