Hi
I have two columns - Date (YYYY-MM-DD) and Sales.
What I want to do is to group (summarize) sales by Month. How can I do this in Alteryx? I have tried many things and looked for the answer on the group, but no luck..
This should be really simple.
thanks
Résolu ! Accéder à la solution.
You can use the DateTime tool within the Parse palette to convert your fields to alteryx recognized dates.
Hi @MarekRe ,
Once you get the date field from DateTime tool, you can format it as you like.
for ex: formula - DateTimeFormat([DateTime_Out], "%Y_%m") will give you the date in YYYY_MM format.
Hope it helps!
Thanks,
S.
I didn't find a way to select the desired output. With this tool, I can only select the desired input. Never mind, answer from @szade1 solved the issue. Thank you for trying.