Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summarize time into 15 minute segments

Talbanese
7 - Meteor

Untitled picture.png

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!

 

 

6 REPLIES 6
Federica_FF
11 - Bolide

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.

 

Cattura.PNG

 

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
7 - Meteor

This is great thank you!

BenMoss
ACE Emeritus
ACE Emeritus

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

Shapna74
7 - Meteor

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:

 

StudentIDStudentSurnameStudentGiven1StudentYearLevelAbsenceEventTypeCodeAbsenceEventDateAbsenceEventDateTime
9984AmandaA11LRCIn30/01/201903:33 PM
9984BecB11LRCOut30/01/201904:09 PM
1111CarolT12LRCIn30/01/201903:31 PM
1111CarolT12LRCOut30/01/201905:40 PM
7777SingSan12LRCIn30/01/201903:59 PM
7777SingSan12LRCOut30/01/201904:13 PM

 

Output:

 4pm5pm6pm7pm8pm9pm
Term 1Monday      
Week 1Staff Day     
Week 242228100
Week 3453112951
Week 4554016761
Week 549261414113
Week 63824191072
Week 737257974
Week 8522610412
Week 981447122

 

Regards

Syeda

nansu
5 - Atom

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

JohnDanahy
5 - Atom

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

Labels