Can you sort renamed values in Data Studio?

Question

I'm working with bar graphs is GDS and I would like to order the bars within a graph. Normally, I'd create a sorter helper field with this formula:

CASE
  WHEN CONTAINS_TEXT(Beautiful-Ugly, "Very beautiful") THEN 1
  WHEN CONTAINS_TEXT( Beautiful-Ugly, "Somewhat beautiful") THEN 2
  WHEN CONTAINS_TEXT( Beautiful-Ugly, "Neither beautiful nor ugly") THEN 3
  WHEN CONTAINS_TEXT( Beautiful-Ugly, "Somewhat ugly") THEN 4
  WHEN CONTAINS_TEXT( Beautiful-Ugly, "Very ugly") THEN 5
END

But I keep getting a system error 5a8152ae. I think it could be because the Beautiful-Ugly field is itself a calculated field that looks like this:

CASE
WHEN 6_Q5="Very ${lm://Field/1}" THEN "Very beautiful"
WHEN 6_Q5="Somewhat ${lm://Field/1}" THEN "Somewhat beautiful"
WHEN 6_Q5="Neither ${lm://Field/1} nor ${lm://Field/2}" THEN "Neither beautiful nor ugly"
WHEN 6_Q5="Somewhat ${lm://Field/2}" THEN "Somewhat ugly"
WHEN 6_Q5="Very ${lm://Field/2}" THEN "Very ugly"
END

Can someone recommend me how to order bars in my chart? Thanks in advance!

Answer 1

等待大神答复