Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sum a column based on month

MJ54
7 - Meteor

I have a column that is displaying dates in the YYYY-MM-DD format and I would like to create an output that counts how many values there are in each month. How would I go about that?

1 REPLY 1
Christina_H
14 - Magnetar

Use a DateTime tool or formula tool to convert the date to a format including only month and year, then use the new column to group and count the data.

Christina_Hurrell_0-1631713265582.png

 

Labels