How can I sort the legend values in a Pie Chart

AttuAk · February 2018

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 · February 2018

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 · February 2018

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 · February 2018

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.

How can I sort the legend values in a Pie Chart

Best Answer

Answers

Categories