Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ksharpes
Creator
Creator

Sort by Expression Pie Chart

Hello,

 

I am trying to arrange the Pie chart to show the legend in a particular order.

 

I have attempted to use the below formula in the sort by expression field but it does not work.

 

Match([Coverage Group],'Short','Medium','Long','Very Long','Dead Stock' and 'NYA')

sort.png

 

Also if the dimension used is a drill down dimension how would the expression look to cover each drill down?

1 Reply
Ivan_Bozov
Luminary
Luminary

Try this: Match([Coverage Group], 'Short', 'Medium', 'Long', 'Very Long', 'Dead Stock', 'NYA')
Also in the sorting options uncheck everything else and leave only Sort by expression.
vizmind.eu