Fix the Y-Axis

[alexlyle]

Can someone help me fix my Y-axis at the end of this flow? It's going in reverse (descending) order. Thanks

[grossal · Accepted solution]

Hi @alexlyle,

I have added a Auto-Field tool to adjust the type of the column.

Fixed workflow attached. Let me know if this is what you were looking for.

Best 

Alex

[alexlyle]

I'm not sure why, but that worked. thanks

[grossal · Accepted solution]

I'll try to explain it:

First off all, you have made one other mistake. But a good one, because you wouldn't have notice the bigger one.

Your sort tool was set to Date an Descending, this sorted it the wrong way! I didn't notice this while fixing it. 

The result looks better, but not right:

At the first glance it looks alright, but it isn't.

You will notice that the distance between the "numbers" is always the same. We are lucky that all numbers increase, else the Y-Axis would have something like "1, 5, 3" because everything is text. And how do you order text on an axis? Right, you just write it in the order it comes in - unless it matches a previous value.

That's what happening. It's important to always make sure your columns have the write data type. Double check this with the meta info tab in the results window or use a Select tool to confirm all number are numbers, all dates are dates and so on.

Hope this make it clear what happens.

[alexlyle]

I appreciate it. I need to build my skills with the charts.