Help adjusting the sort order of a stacked bar chart in a drilldown.

tim_treacy
Tera Contributor

I've built a report that has a stacked bar chart as a drilldown.

The chart is set to stack by Priority, however, it seems the default sort order for this is to place the highest priority at the bottom of the bar (Screenshot_23). 

I've set the Sorting Order for Priority in the report conditions.  There are 3 options (a-to-z / z-to-a / -none-), but none of these seem to have any effect on the chart in the Drilldown (Screenshot_25).

Editing the Drilldown itself is not a solution either, as there are no conditions to modify (Screenshot_26).

The closest I've gotten to something resembling progress was a warning that my sort order was invalid (Screenshot_27).  Although the reason it's "invalid" is that order by can only be used on the 'stacked' field, which is exactly what I'm trying to do.

 

Given that having the highest priority items at the bottom of a stacked bar is counter-intuitive to most humans, does anyone know if a solution exists for adjusting sort orders in a drilldown chart?

2 REPLIES 2

Jonah Piascik
Tera Expert

@tim.treacy - did you make progress on this?

Unfortunately no.  As best I can tell, there is no viable method for applying a sort order to a drilldown chart.