Counting Calls in 30 mins increments

[oaevangelista2023]

Hello,

Attached is a sample data file which lists calls made by date and time. I am trying to develop a workflow that groups the time into 30-min increments (i.e. 7:00:00 AM, 7:30:00 AM, 8:00:00 AM ) and count the number of calls for each 30-min increment. I can use a Formula tool but would require 48 IF-THEN-ELSE statements. Would there be a more efficient way to accomplish this?

Would be greatly appreciated if someone in the community can assist 

Thank you!

[gawa]

hi @oaevangelista2023 

In your case, I recommend to prepare 48 time zone group in advance, and cross-check with the input data like this.

Advantage of this way is that if you want to analyze data not only for 30mins but also for 15mins, 10mins...it can be easily adjusted on configuration of Generate Ros tool and Formula tool without having to change WF drastically.

Please have a look at the attached WF to see how it works.

[Qiu]

@oaevangelista2023 
Maybe there is a better way.
We can use the Generate Rows Tool to generate all the 30 minutes interval, then use Append tool for filtering.

[Qiu · Accepted solution]

@gawa 
I forgot about the Count part 😁

[oaevangelista2023]

Thank you for the solution

[Qiu]

Glad to help.