Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Months Without Alphabetical Order

Highlighted
7 - Meteor

My reports keep putting the "Month" in alphabetical order. How do I get it to know that I need them in calendar order? Thanks!

Alteryx Certified Partner
Alteryx Certified Partner

@rwicker

 

I recommend creating a new field that converts the current date labels to a numeric format by using the following formula DateTimeParse([Name],"%b_%Y"). This new field can be sorted and this will correct your chart.

 

An example solution is attached.

 

Highlighted
7 - Meteor

Thank you Charlie!! This worked perfectly and has solved so many issues with other reports. ! Thanks again!

Labels