Interactive Chart - Editing order of X Axis

[Zach9396]

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!

[CharlieS · Accepted solution]

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. 

[Zach9396]

Ah okay, it worked, thank you!