Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been trying to sort my 'Others' field in my chart as the last bar, but I haven't been able to do it in any way. Could anyone help me?
Greetings,
Lucas
Have a look at the Sort tabs on each of the charts in the attached. I've added a sort by expression that sorts the Others value as last. The expressions looks like this:
=aggr(count(Customer),[SLS Organization])
where the dimension for the aggr() function is the dimension on the corresponding chart.
As far as I am aware, the others bar automatically sorts as the last one. Are you applying some other type of sorting and still want the 'others' to appear last? If so, please upload a sample and I will have a look at it for you
Cheers,
Byron
Hi Byron,
I am not using any type of sorting. I even tried removing the sorting properties in the document settings, but it still shows at a random position in the chart.
Greetings,
Lucas
Have a look at the Sort tabs on each of the charts in the attached. I've added a sort by expression that sorts the Others value as last. The expressions looks like this:
=aggr(count(Customer),[SLS Organization])
where the dimension for the aggr() function is the dimension on the corresponding chart.
That worked! Thanks!