Is it possible to enforce ordering on Mode's legend labels?

Hi, see the attached screenshot. I expect the ordering to go (A), (B), (C), ... , (F) but (B) is the 5th in ordering. Any strategies for enforcing the order of the legend's labels?

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Steven Wu !

    Here is some background information about how legends are ordered currently: 

    #1 By order of appearance of the series Lets say where your x-axis is months, and you have a stacked bar chart, if only one series appears in month 1, it will be at the top of the list. And by the same logic, if one series only appears in month 2, it will be the second series.

    #2 Alphabetical After evaluating the appearance order of the series, it will then rank them alphabetically. If all of the series appear in the first month, then they'll just be alphabetized. The important thing here is that alphabetical order isn't the same thing as numerical order. So if a category is called "100", it will appear before a category called "2", because the first character (1) comes before (2), the same way Apple would come before Bee.

    At this point, there is no way to manually overwrite this logic. Sorry about that! However, we could also recommend using Python Notebook to plot charts where you want to have more control over legends ordering. For example https://modeanalytics.com/modeanalytics/reports/a522c1d62187
    You can view the code by clicking View Details -> Notebook.

    With that being said, we do have an open feature request for this functionality,  happy to add your voice to this request and reach back out once this is available in Mode.

    Like
  • I would love to be able to configure just having alphabetical ordering (independent of whatever x-axis I choose to have in my graph). If it's an easy fix I think it would be very impactful - I get a lot of confusion from my end users around the ordering of the labels, and personally I sympathize with them in not understanding why the order of appearance in the x-axis series should matter (and I don't understand why this more complex rule is the default over a more simple one). Thanks for the response!

    Like
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 2Replies
  • 32Views
  • 2 Following