Chart has month as X axis and time on Y axis. however time is not sequential. I have selected data type as time?
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?
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).
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. 🙂