Strange behavior of interactive chart

Question

Hello,

This is my first try of creating a chart.

I did quite a simple one, charting a stock price history: Date on X axis and Close price which is a Double field on Y axis.

I would expect to have the Close price sorted correctly. To my surprise, it is not sorted.

What do I miss?

I am attaching the package below. Thank you for your help.

Kind regards

Pomme.yxzp

meljaafari · Accepted Answer

Hi @Jean-Charles , What version of Alteryx Designer are you using? I just tried your workflow with 2020.2, and even though it showed the wrong result first, as soon as I removed the field Close in the Interactive Chart, and added it again, it worked fine.

If running the same version as mine, I don't see any reason why you'd have a different result.

If running an older version of Designer, can you try to add a data cleanse tool (prior to the interactive chart). The fact null values are within the data may be a reason why it's not giving you the right result. Once data cleanse added, try to remove the field on the interactive chart and add it again.

Cheers,

Mo