Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately. What I want to do and can not do is a table that groups me the calls received by the hour (i wanted to do 24 intervals). For example:
Interval Count calls Seg call
00:00am a 01:00 am 5 1560
01:00 am a 02:00am 15 15560
Is there any way to do that?
HI, ty for the answer but Had i table like this:
Hour Time call (sec)
01:15 am 15
01:27 am 25
I want to do a table like this
Interval Numbers call Time Call
00:00 a 01:00 0 0
01:00 a 02:00 2 40
etc.
Is it possible?
@mrtincho wrote:
I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately
Use the Hour() function to create an additional field with the hour of the time part of the unix timestamp.