Break times into specific intervals (15 mins)

[#1]

I have a data set with the following columns

* StatusStartTime

* UserID

* StatusName

I want to be able to break the StatusStartTime which can be anytime up to the second into 15 mins interval and do a count on Status Name.

For e.g I want to know in a specific 15 min interval how many agents were on the "Available" status.

Any help/suggestion on how I can go about doing that would be much appreciated.

Thanks,
Amit

[Clever_Anjos · Accepted solution]

At load script create a field with

LOAD [otherfields]

StatusStartTime,

Floor(StatusStartTime,1/(24*4)) as StatusStartTimeGap

[#3]

Thank you!