Calculated Fields for Likert Scale Survey Questions in Google Data Studio

INPUT:

If your survey responses output into text values instead of numbers, create a calculated field within your data source where

 When X (“5” and “A_43” in the examples below) is your question column containing the range of values, you put a when statement for each response in your Likert scale range. I prefer to make the most positive response 5 and least positive response 1 so that when you go to apply this on a chart under "sort" in the side panel, you can use the "average" of whatever you named the data source you just made and the scale will sort ascending or descending based on your preference. This keeps your named likert scale response values in the legend, or on the axis, but sorts them based on the number you just assigned each value. 

EXAMPLES

CASE
    WHEN 5 = "Very Appealing" THEN 5
    WHEN 5 = "Somewhat Appealing" THEN 4
    WHEN 5 = "Feel Neutral" THEN 3
    WHEN 5 = "Not Very Appealing" THEN 2
    WHEN 5 = "Not at all Appealing" THEN 1
END

CASE
    WHEN 5 = "Definitely Would Purchase" THEN 5
    WHEN 5 = "Probably Would Purchase" THEN 4
    WHEN 5 = "Might or Might Not Purchase" THEN 3
    WHEN 5 = "Probably Would Not Purchase" THEN 2
    WHEN 5 = "Definitely Would Not Purchase" THEN 1
END

CASE
    WHEN 5 = "Very Important" THEN 5
    WHEN 5 = "Somewhat Important" THEN 4
    WHEN 5 = "Feel Neutral" THEN 3
    WHEN 5 = "Not Very Important" THEN 2
    WHEN 5 = "Not at all Important" THEN 1
END

CASE
    WHEN 5 = "Very likely" THEN 5
    WHEN 5 = "Somewhat likely" THEN 4
    WHEN 5 = "Not sure" THEN 3
    WHEN 5 = "Not very likely" THEN 2
    WHEN 5 = "Not at all likely" THEN 1
END

CASE
    WHEN A_43 = "Agree completely" THEN 5
    WHEN A_43 = "Agree somewhat" THEN 4
    WHEN A_43 = "Feel Neutral" THEN 3
    WHEN A_43 = "Disagree somewhat" THEN 2
    WHEN A_43 = "Disagree completely" THEN 1
END

OUTPUT
It looks like the code is defining a calculated field in a data source for a survey with multiple questions that use a Likert scale. A Likert scale is a type of survey question that asks respondents to rate their agreement or perception of something on a scale, often from 1 (strongly disagree or least favorable) to 5 (strongly agree or most favorable).

The code uses a CASE statement to map each response option in the Likert scale to a numerical value. For example, in the first CASE statement, the response "Very Appealing" is mapped to the value 5, while "Not at all Appealing" is mapped to the value 1. This allows the survey responses to be sorted based on the numerical values that have been assigned to them.

It looks like the code is defining a calculated field for each of the survey questions that use a Likert scale. The calculated field is named X in the first line of each CASE statement, but the actual name of the calculated field could be anything. The calculated field could then be used in a chart, and the responses could be sorted based on the average of the calculated field by using the "sort" option in the side panel. This would allow the responses to be sorted in ascending or descending order based on the numerical values that have been assigned to them, while still displaying the named response values in the legend or on the axis.