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

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
Best Answer
-
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).
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"2
Answers
-
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).
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"2 -
@JaneneStarr, did ckatzman's reply help answer your question?
0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive