Time on Y axis is not sequential

[Mandy_Phillips]

Chart has month as X axis and time on Y axis. however time is not sequential. I have selected data type as time?

[DataNath]

Hey @Mandy_Phillips, before building your chart in the interactive chart tool, have you sorted your times so they’re in the right order? I.e. with a sort tool, putting this on your target (time) field either descending or ascending?

[FilipR]

You can try sorting your input by Date first (for the X axis) and then converting the time into a number (for the Y axis).

[Adrian_T]

Hi @Mandy_Phillips, believe the Sort Tool suggested by the others should work just fine. I thought to also share an extremely useful Tool Mastery resource on the Interactive Chart Tool, in case you have not come across this. 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Interactive-Chart/ta-p...