community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Sequence of bars in chart

Meteoroid

 

Hey all,

 

I'm happy with the positive numbers in the chart below, but for the negative numbers I would like to have the largest negative bar at the top and the smallest at the bottom. Anyway to do this?

 

Regards,

Robert-Jan

 

 

chart.jpg

Highlighted
Alteryx Certified Partner

Hi Robert-Jan - If you add a sort tool that sorts by the amount field in Descending order, your bars should be sorted with the largest negative bar at the top and smallest at the bottom.

 

Hope that works!

Alteryx Partner

Hi RobJanBou,

 

In this link other people of the community suggest to Alteryx to put a sort/order into the charting tool.

 

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Bar-Chart-Sort-Order/idi-p/6837

 

I think it's still under review.

 

In the meantime (that other users propose a solution), you can try to put a sort tool before the charting tool. i created a "mini-flow" and it works.

 

alteryx3.PNG

 

Meteoroid

Thanks a lot, works like a charm!

Labels