Incorrect order on the y-axis - Interactive Chart

[akishizuha]

Hi all,

I'm having some problems when trying to create a line chart with date on x-axis (v_wstring datatype), and standard deviation (fixed decimal, 19.3) on the y-axis. There are no null values (I've changed them to 0 instead) within the dataset. 

However, I can't get the y-axis to order correctly by numeric value:

I've seen similar questions in discussion but none of the fixes seem to work for me. Can anyone help me to look at this?

Thanks a lot! 

[Laurap1228 · Accepted solution]

See if the attached workflow helps.

[akishizuha]

Thank you so much - the attached workflow helps. I managed to solve this by pasting my columns into the text input tool, and then the graph became normal. 

I'm not sure if it's because some of the other columns I have in the dataset causing the problem.