Welcome to the Forums.
I'm not sure about your specific questions,
but just wanted to pass along some key
references for Tableau and Survey data:
1 of 1 people found this helpful
How do I create a calculated field that would have a value of 1 if Q4 is 7 or more?
You can create an expression with condition, e.g.
if([Question ID] = 'Q4' and [Values] > 7, 1, empty())
or in its simpler form
when([Question ID] = 'Q4' and [Values] > 7, 1)
If you are expecting to have many conditions like that, the "Rule" action can be a better idea because it's more convenient for multiple "IF..." statements.