Arrangement in Bar Graph

Jez Member

November 21 in Charting

Hello, is there a way to rearrange the order of legend in Bar Graph? My card looks like this:

Tr - bottom

Ac - middle

Ro - Top

I want to rearrange the order like this:

Ro - Bottom

Ac - Middle

Tr - Top

Thank you.

0

Best Answer

• 

  GrantSmith Coach

  November 21 Answer ✓

  You can use a beast mode to define a custom sort value to use in the sorting section of your chart

  CASE WHEN `field` = 'Ro' THEN 1
  WHEN `field` = 'Ac' THEN 2
  WHEN `field` = 'Tr' THEN 3
  END
  

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  1

Answers

• 

  GrantSmith Coach

  November 21 Answer ✓

  You can use a beast mode to define a custom sort value to use in the sorting section of your chart

  CASE WHEN `field` = 'Ro' THEN 1
  WHEN `field` = 'Ac' THEN 2
  WHEN `field` = 'Tr' THEN 3
  END
  

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  1
• 

  Jez Member

  November 21

  @GrantSmith this works. Thank you!

  0