Sort legend A-Z in Ascending/Descending charts

I took the screenshot below to display a few things:

 

-I have a grouped bar chart, sorted from Most to Least.

-The sort order is based on an aggregate count of values across all the different categories in my series.

Because of this, the legend order and color scheme are set based on most to least count of those values. I tried adding my series name next in the sort order to get the legend to sort, and it did not work.

 

I would like to sort this series A-Z, first because logically that is how my users would expect ot read this chart, and second because it is one of a handful of charts with this exact display, and I want to ensure the orange bar is alwys the same "show name", likewise blue, etc. etc. 

 

I know ideas have been submitted/Liked about creating rules for assigning colors to string values, and since that is not yet available I would at least like to be able to sort my legend and the assignment of colors in a series Alphabetically.

 

I included a screen shot layered on top here to show what options are available in the "General" chart properties, and the most flexibility I have is to sort in reverse -- I've found that comes in handy for certain types of charts when pulling into Powerpoint, but within Domo I would rather be able to show the legend alpha on this chart style.

 

I've been able to force the sort order in other chart types using Beast Mode, etc, but it seems that the combination of the grouped bar chart and the sort I had to put on to get it to display aggregate most to least prevents me from being able to control the order of the legend and color assignment. 

 

Capture.PNG

Broadway + Data
2
2 votes

· Last Updated

Comments

  • @RobynLinden I noticed that legend quite often sorts based on the sequence in the data file. I.e. the first legend item is the first occurence of the label. So, maybe a temporary solution would be to sort your source data in the order you want?

  • Interesting idea! Funny enough each item in the series has its own datasource, which is then appended together to great the datasource powering this card. The labels in the legend are actually constant values added in that process. But maybe I can reorganize the ETL so that the components are in alphabetical order on the work space before I drag my arrows to make my ETL.

    Broadway + Data
  • Thank you @RobynLinden.  Assigning to our product manager @ckwright for review.

  • @RobynLinden Thanks for this information this is very valuable. I will talk with @Gavatar and the team about your request

This discussion has been closed.