1 Reply Latest reply on Oct 1, 2018 12:20 PM by tanvi khanna

    Want to use excel countif for surveydata

    tanvi khanna

      Hi,

      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.

      count(IIF([Q1]=5,1,0))/count([Q1])