Organize Time Count

[knozawa]

I would like to organize the time count by hour.

Sample Time Data

I sprit them into Hour, Min, and Sec.

I would like to create a table like this

Does anyone know how to do this using Alteryx tool?

Thank you,

Kazumi

[dataMack]

If you already have the step of splitting the time into its components including hour, then just drag a 'Summarize' tool onto the canvas, add 'Hour' as your Group By field and then Hour again as a Count field.  That will give you the table you want below.

[knozawa]

Hi Jason,

Thank you for your suggestion.

However, there are missing hours and it doesn't show in the table (1, 5, 23).

Do you think it is possible to present "0" count in the table?

Thank you,

Kazumi

[DanHare · Accepted solution]

Hi If you were to do the following it should work ; * create a text input source with numbers from 1-24 as hours, with 0 as count * JOIN to your outputs, let's say that your text input above is Right source * then you could UNION the Join and Right outputs together.

[knozawa]

Thank you very much! I was able to do that successfully.

Sincerely,

Kazumi

[DanHare]

Welcome !