Interactive Chart - Editing order of X Axis

Question

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!

Capture.PNG

CharlieS · Accepted Answer

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.