Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Interactive Chart - Editing order of X Axis

Highlighted
5 - Atom

Hello,

 

I am new to using the reporting tools & I am trying to create a line chart over time. The X-Axis is a concatnated string of month & date (Ex: January 2019 is 1-2019). The order of the dates are incorrect in the chart and I can't figure out how to rearrange the x-axis points. 

 

Thank you!

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Alteryx uses ISO 8601 for the official date time format. This looks like "2019-06-25 15:32:00". Format your date values in this format "2019-01-01" and they can be sorted to their chronological order. 

Highlighted
5 - Atom

Ah okay, it worked, thank you!

Labels