1 of 1 people found this helpful
On way to do this is to specify the datatype in Excel---make the column a text column. Then in Tableau, you can create a calculated field to parse this; for example:
WHEN "satisfied" THEN 10
WHEN "neutral" THEN 5
WHEN "dissatisfied" THEN 1
WHEN "yes" THEN 10
WHEN "maybe" THEN 5
WHEN "no" THEN 1
If you do not want to convert the text values (and instead want to show % of responses in each category), then you'll need to create multiple worksheets and combine them in a dashboard. There are many ways to do this, but I might create three Answer fields, one for each question type (numeric, satisfied, and yes/no/maybe).
Thanks for your quick and helpful response!
I will test the solution, you suggested, in "real life" and possibly get back!