Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Time on Y axis is not sequential

Mandy_Phillips
5 - Atom

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

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

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
11 - Bolide

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
Alteryx Alumni (Retired)

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...

 

Labels
Top Solution Authors