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

Mike_Y — Fri, 15 Mar 2019 21:42:34 GMT

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.

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

kaushiknsolanki — Sat, 16 Mar 2019 06:02:45 GMT

Hi,

What sorting options you have selected under Sorting Tab?

Regards,

Kaushik Solanki

topic Re: Bar chart sorting order not correct - only legend order has problem in App Development

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

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