Summarize time into 15 minute segments

[Talbanese]

Hello,

I am trying to take time and summarize it into 15 minute segments. So in the below example between 1:00 and 1:15 there were 6 items and 1:15-1:30 there were 5.

I have the field seperated from the date but also have Date and Time togther in another field.

Thanks!

[Federica_FF · Accepted solution]

HI,

in attachment you can find a simple workflow that starting from a generate rows tool, generates all the time of the day, starting from 00:00, adding +1 minute per row, to 23:59. In the second column a label groups the rows in segment of 15 minutes.

You can use it as joining table for your data, joining by Time=Arrival Time and then connect the J output connector to a summarize tool that counts the rows gruped by Time bins.

[Talbanese]

This is great thank you!

[BenMoss]

Awesome @Federica_FF, used this yesterday, works a charm :)

[Shapna74]

Hi Meteor

As i am new to alteryx , i am not very sure how to do a similar report. We have students login and logout time.

I need to do a summary  report for hourly basis, like 4pm, 5pm,6 pm how many students were logged in.

Input:

StudentID	StudentSurname	StudentGiven1	StudentYearLevel	AbsenceEventTypeCode	AbsenceEventDate	AbsenceEventDateTime
9984	Amanda	A	11	LRCIn	30/01/2019	03:33 PM
9984	Bec	B	11	LRCOut	30/01/2019	04:09 PM
1111	Carol	T	12	LRCIn	30/01/2019	03:31 PM
1111	Carol	T	12	LRCOut	30/01/2019	05:40 PM
7777	Sing	San	12	LRCIn	30/01/2019	03:59 PM
7777	Sing	San	12	LRCOut	30/01/2019	04:13 PM

Output:

	4pm	5pm	6pm	7pm	8pm	9pm
Term 1	Monday
Week 1	Staff Day
Week 2	42	22	8	1	0	0
Week 3	45	31	12	9	5	1
Week 4	55	40	16	7	6	1
Week 5	49	26	14	14	11	3
Week 6	38	24	19	10	7	2
Week 7	37	25	7	9	7	4
Week 8	52	26	10	4	1	2
Week 9	81	44	7	1	2	2

Regards

Syeda

[nansu]

it's a good solution, help me a lot!

[JohnDanahy]

This solution helped me out a ton, and is easily customizable as well.  You are awesome.