Aggregate Dates by Month

[jasminesang]

Hello, I am looking to group and aggregate data by month so I can pivot it. Please see attached picture for quick view of what my data looks like vs. what i want it to look like. Thanks!

[AlteryxUserFL]

Here is an example 🙂 

Updated: Add new flow with text month instead of number. 

[NickSm · Accepted solution]

Hey @jasminesang 

Can parse the date with a formula tool - the %B character returns just the month.

[MichalM]

@jasminesang 

A simple DateTimeParse would do as well assuming the dates are in Date format

[tosinico]

Hi. What if I have a date like 01/27/2022 and I want to summarize data by month and years so in the chart I am able to see the years and the months?

Thanks

[MichalM]

@tosinico 

You can first convert your date to yyyy-mm-dd format

And then follow the same as above and add a year as well

You can find all the different date formats available here
https://help.alteryx.com/20223/designer/datetime-tool#custom-format

[tosinico]

 @MichalM thanks!