I am relatively new to Tableau.
I have a data set generated from a survey. All of the questions are in one column called "Questions", and likewise, all responses are in a column called "Answers." Many of the the questions involve 7-point Likert scale responses, but the scales mean different things for different questions.
For instance, if a question is about thermal comfort, a "1" on the scale might mean "Too cold." But if a question is about employee engagement, a "1" on the scale might mean "Not engaged."
The problem is that these labels are not included in the data; the value in the "Answer" column for both questions is simply "1". It is easy enough to sort and create sets around questions in order to separate the responses. HOWEVER, if I try to create an alias for the response, say make the response "1" = "Too cold", it applies this alias to ALL responses so that now a reponse of "1" to the question "How engaged are you feeling?" would be "Too cold."
I'm trying to avoid significant reshaping of the data. Is it possible to create aliases by sheet or by set that don't apply across the entire column?
Thanks in advance.

Hey Josh,
Wanted to share this with you, as a preliminary (This assumes your Data Structure is as you described)
You were right on the point with your Calc, I modified it slightly to use IF statements, but that is personal preference
IF CONTAINS([Question], 'Thermal')
THEN
IF [Response] = 1 THEN 'Too Cold'
ELSEIF [Response] = 2 OR [Response] = 3 THEN 'Cool'
ELSEIF [Response] = 4 THEN 'Just Right'
ELSE 'Hot'
END
ELSEIF CONTAINS([Question], 'Engagement')
THEN
IF [Response] = 1 THEN 'Not Engaged'
ELSEIF [Response] = 2 OR [Response] = 3 THEN 'Barely Engaged'
ELSEIF [Response] = 4 THEN 'Engaged'
ELSE 'Really Engaged'
END
END
Regards,
Rody