Pie chart sorting

[Johnathon Martin]

Hello - we have a set of pie charts displaying data based on a staff responses to questions.

The responses are always one of:

Very Good

Good

Ok

Not Very Good

Terrible

We want it so the pie chart sorts them as listed above. However we seem to only be able to do it by percentage size or by alphabetical order.

Is there a way to change this?

[Marcos Alcozer]

Hi Johnathon,

If you add a question_response_id column to your dataset that's an integer, can you sort by that in the chart's settings?

Very Good --> 5

Good --> 4

Ok --> 3

Not Very Good --> 2

Terrible --> 1

Marcos Alcozer

Registered in England. No 04760864. Registered office as above

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. 

If you received this in error, please contact the sender and delete the material from any computer.

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/bc3d0239-9ef7-4ec3-b2f4-76d04b2f15d9n%40googlegroups.com.

[Laura Tilton]

The easiest way is to pre-code your responses (Google Form?) with a built-in sort (5 - Very Good, 4 - Good, etc.) That doesn't help you right now, though, unless you want to update your data set to include the leader number. Then when you sort "alphabetically," it will sort the way you want it.

If you don't want to edit or add anything to the data set itself, you can use a chart-level calculated field for your Sort using a CASE statement, like this:

CASE

WHEN Response="Very Good" then 5

WHEN Response="Good" then 4

etc.

END

Then, make sure the Sort aggregation is set to AVG and it will sort in the order you want.

Laura

[Chris Smith]

I agree with Laura's suggestion.  If it isn't set up from the beginning, throw a CASE statement into a calculated field and then sort by the new calculated field.

-Chris

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAN4-922JOtSrm_6cw1FhrPBtYQrczczDONEuiDxCrR_v4QwFyA%40mail.gmail.com.

--

Singapore American School

Chris Smith | Data & Innovation Specialist |  APLS

 Apple Distinguished Educator |  Apple Certified Teacher | Google Certified Innovator

40 Woodlands Street 41 | Singapore 738547

Phone: +65 6360 3406 ext 6165

---

CONFIDENTIALITY CAUTION: This message is intended only for the use of the individual or entity to whom it is addressed and contains information that is privileged and confidential. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this communication. If you have received this communication in error, please notify us immediately by return email and delete the original message. Unless it relates to the official business of Singapore American School, any opinions or matters expressed in this message are those of the individual sender.