1 Reply Latest reply on Jun 19, 2017 11:39 PM by Martin Waschipky

# Calculating Top 2 Score of likert scale

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!

• ###### 1. Re: Calculating Top 2 Score of likert scale

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.