Hi everybody,
I am pretty new to tabelau and i have a little question. I created a dashboard with nice likert plots, I followed this nice tutorial: Likert Scale Tableau - YouTube
As part of the data preperation I transformed the data in R using the gather function, so it was not nessesary to pivot the data in tableau.
Additionaly I need to calculate in another sheet the Top 2 Score of my Data (see Example)
Antworten ausformuliert | Frage | Kennzahlwerte |
not important | F2A1 | 94 |
little important | F2A1 | 75 |
partially important | F2A1 | 16 |
important | F2A1 | 8 |
very important | F2A1 | 3 |
So the answer would be: 8+3/196 = 5.6% think it is important/verry important.
How can I achive this goal?
Thanks for your help!
I found the answer myself:
I created a calculated field: TOTAL(SUM(if [Antwort] >= 4 then 1 ELSE 0 END)) / [Number of distinct observations] and added a tabular calculation based on the item/question.