Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Sequence of bars in chart

RobJanBou
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

3 REPLIES 3
nick_ceneviva
11 - Bolide

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!

EmanueleE
8 - Asteroid

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

 

RobJanBou
6 - Meteoroid

Thanks a lot, works like a charm!

Labels