Alteryx Designer Discussions

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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

SOLVED

Sequence of bars in chart

Highlighted
6 - 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!

Highlighted
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

 

Highlighted
6 - Meteoroid

Thanks a lot, works like a charm!

Labels