How to force legend to stay in a Specific order
I have two questions:
1. Is there a way to sort the legend in a specific order and have it stay that way?
I would like it to be as follows:
A
B
C
D
F
But I am having trouble finding the option in chart properties.
2. There is also an extra option in the key that is showing up that doesn't apply to anything. Is there a way to get rid of that?
I have attatched a screen shot for better understanding
Best Answer
-
You have to make sure your sort is set to "No aggregation"
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
Normally I will use 2 sorts to achieve this.
If your X axis is your date range, first add your date value to your sort (to keep that from getting messed up). Then add a 2nd sort for your Series value. That will allow you to set it Ascending or Descending alphabetical order.Hope that helps,
Valiant
1 -
Hello,
Yes, drag your series into the "sorting" section and to get rid of the unwanted value, drag your series in the "filters" section and choose "Not In" and then select the blank value.
Hope this helps
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
When I add my series to the sort section it is only altering the table setup and the order it is stacked in. But it is not changing the legend order. Any advice on that?
0 -
You have to make sure your sort is set to "No aggregation"
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Please use beast mode calculation as below:
Rank_Order:
CASE
WHEN field = 'A' THEN 1
WHEN field = 'B' THEN 2
WHEN field = 'C' THEN 3
WHEN field = 'D' THEN 4
WHEN field = 'F' THEN 5
END
Use this beast mode calculation in sorting(ascending).
Hope this helps!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 689 Automate
- 177 Apps
- 454 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive