Bar chart sorting order not correct - only legend order has problem

[Mike_Y]

Hi guys,

I am having a very strange issue where my stacked bar chart dimension order is correct but the legend order is not.

I have implemented a customized sequence using the dual() function.

=if(bookingstatus = 'Unbooked',
 if(prioritised_to_date >=0 and prioritised_to_date <= 14,dual('1-14 Days',1),
 if(prioritised_to_date >=15 and prioritised_to_date <= 30,dual('15-30 Days',2),
 if(prioritised_to_date >=31 and prioritised_to_date <= 60,dual('31-60 Days',3),
 if(prioritised_to_date >=61 and prioritised_to_date <= 90,dual('61-90 Days',4),
 if(prioritised_to_date >=91 and prioritised_to_date <= 120,dual('91-120 Days',5),
 if(prioritised_to_date >=121 and prioritised_to_date <= 150,dual('121-150 Days',6),
 if(prioritised_to_date >150,dual('>150 Days',100)))))))))

Please find more details from the screenshot.

Can you help me solve this problem, please?

Have a good day.

[kaushiknsolanki]

Hi,

What sorting options you have selected under Sorting Tab?

Regards,

Kaushik Solanki