I have a set of survey data and need to calculate the client index for every question as well as for all 3 questions i.e.
for every question the client index would be count(5's in responses)/count(all responses)
and average of these 3 numbers is the overall client index. I have attached the excel calculations which needs to be replicated in tableau.
I tried this in tableau, however I do not get count of 5's in numerator.
I tried this and it worked, just wanted to share if someone is stuck like me!