How do you sort bars on a graph based upon values?

JaneneStarr

I have business units on my x axis and sold units on my y axis.  I'd like to sort my business unit from largest to smallest sold units, so that the business units with the most sold appear first in my graph

ckatzman

Hi Janene - 

 

Should be able to take your sold units attribute, add it to the Sorting box on the edit screen, select your same aggregation type (Count?  Sum?), and select the Descending option.  What you won't want is to have your business unit reflected in the Sorting box, or if you do, have it below the sold units counter so that it becomes a secondary sort (ie, two business units with same name, you'd want the larger one to come first).

ckatzman

Hi Janene - 

 

Should be able to take your sold units attribute, add it to the Sorting box on the edit screen, select your same aggregation type (Count?  Sum?), and select the Descending option.  What you won't want is to have your business unit reflected in the Sorting box, or if you do, have it below the sold units counter so that it becomes a secondary sort (ie, two business units with same name, you'd want the larger one to come first).

kshah008

@JaneneStarr, did ckatzman's reply help answer your question?