Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Months Without Alphabetical Order

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.

 

7 - Meteor

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

Labels