Hello friends, I'm back with another question. In DQL, I need to do the following: I have a record that contains the start time and end time of a problem or event, and I would like to transform this record into a time series. For example:
The record is event_start=18:15, event_finish=18:35. When I convert it to a time series with a 5-minute interval, from 18:00 to 19:00, the result is {"","","1","","","","","","","","",""}, but considering the end time, it should be: {"","","1","1","1","1","1","","","","",""}, since the event existed during all those intervals.
This would be very helpful when I want to calculate the availability of a service when events overlap.
