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!

Call_data.xlsx

Best Practices

Time Series

Accepted answers

Qiu

@gawa
I forgot about the Count part 😁

All comments

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.

1238077_gawa.yxzp

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.

0207-oaevangelista2023.yxmd

Qiu

@gawa
I forgot about the Count part 😁

oaevangelista2023

Thank you for the solution

Qiu

Glad to help.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335