How can I sort the legend values in a Pie Chart

AttuAk

Is it possible to sort the order of the values in the legend in a Pie Chart?  

I'd like to sort this to read:

• High Engagement
• Medium Engagement
• Low Engagement
• Not Engaged

But by default I am getting this:

Tomo

Hi. @AttuAk

 

CHART PROPERTIES > General > Unsorted Data:　ON

SORTING > [Sort Column]

 

[Sort Column] Make BEAST MODE

 

case
  when `EngagementType` = 'High Engagement' then 1
  when `EngagementType` = 'Medium Engagement' then 2
  when `EngagementType` = 'Low Engagement' then 3
  else 4
  end

Tomo

Hi. @AttuAk

 

CHART PROPERTIES > General > Unsorted Data:　ON

SORTING > [Sort Column]

 

[Sort Column] Make BEAST MODE

 

case
  when `EngagementType` = 'High Engagement' then 1
  when `EngagementType` = 'Medium Engagement' then 2
  when `EngagementType` = 'Low Engagement' then 3
  else 4
  end

AttuAk

Hi Tomo,

Thank you for your answer.  It worked perfect. The key was to see the:

CHART PROPERTIES > Genearl > Unsorted Data: ON

I didn't know about that.

 

Thanks for your help.  It worked great.