Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have issue trying to sort my bar chart legend.
The current legend is
100
300
250 (New)
260 (Old)
Others
How can I sort the above into:
100
250 (New)
260 (Old)
300
Others
TIA
You can Make them Dual values.
so dual(‘100’,1) dual(‘250 ( new)’,2) dual(‘300’,4) etc. So it will be sorted by numeric values
if above values are static you can also create inline table then use Bucket_order field for sort.
make sure first field should be same in both tables.
Inline:
LOAD * Inline [
Bucket,Bucket_order
100,1
250 (New),2
260 (Old),3
300,4
Others,5
];