Is their a tool in Alteryx where I can aggregate time slices in my input Data?
For E.g.: I have got a column with Time and Date as below:
I want to aggregate these time slices into 15 minutes as below like from 05/01/2018 00:00 to 05/01/2018 00:14 to 05/01/2018 00:15 and so on. Appreciate your help! Thanks in Advance.
Solved! Go to Solution.
I don't know of a tool that can aggregate them directly, you'll likely need to do some manipulation first. Something like:
This finds the number of minutes "over" the last 15 minute mark and subtracts them out of the time. After that, it's just a group by in the Summarize tool. Note that if the datatype is already date/time you don't need the DateTime tool.
Hope it helps!
Thank you for the solution. This really helped!!