Can you add a custom sort open on nested fields, (e.g. the second dimension in a stacked bar chart)
Currently you can only change the primary dimension. e.g. I want a stacked bar chart sorted by date, then then the stacks sorted by largest value. like this
Hi @wildcard440,
As the ability to sort by multiple fields is available in other visualization types, I agree it would be nice to have included in stacked bar charts as well, I’ll keep this marked as a feature request.
One additional note/thought; Stacked bar charts do allow you to sort by the ‘group/color’ section as a second sort option…unless your value is being used in your group color field (which I doubt) then it still wouldn’t sort the way you’d like. But I’m wondering if you could craft a calculated field that ranks the value by whatever your group color field is, then you could use that in your group/color section so that you’re able to sort by the ranking (which would reflect the values in proper order).
You can then edit your tool tip to include the original group/color field so that you still have the proper information included.
I know it’s a couple extra steps but may work out in the interim!
Hi, @wildcard440, did Brett’s suggested solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Suite Community Q&A Forum!
