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

how to automatically group the datetime data into hours?

luo
8 - Asteroid

I have a column of data that looks like below:

DateTime

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:03

2020-01-14 16:00:05

2020-01-14 16:00:05

2020-01-14 16:00:11

2020-01-14 16:00:13

2020-01-14 16:00:13

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:14

2020-01-14 16:00:15

2020-01-14 16:00:15

2020-01-14 16:00:16

2020-01-14 16:00:16

2020-01-14 16:00:17

I have three month data and I want to group the data into one hour. Means I want to see how many records per hours. Is there a way to do this? Thank you guys.

1 REPLY 1
Emil_Kos
17 - Castor
17 - Castor

Hi @luo,


The magical formula that will help you is:

 

Left([DateTime], 13)+':00:00'


Please see the workflow below:

 

Emil_Kos_0-1616143724992.png

 

Labels