5 Replies Latest reply on Dec 15, 2014 12:59 PM by Trudy Walter

    How do I calculate top box performance from a survey?

    Steve Viglione

      This is probably a very easy calculation, but I can't get it to work.  I've got a website survey that asks how successful a person's visit was.  They are responding on a 5-point scale. I am looking to calculate the number of people that responded with a 5 and divide that by total responses (1-5).  This would show the success rate.

       

      I created a calculated metric that reads:

       

      COUNT([how_successful]=5)/COUNT([how_successful])

       

      It says the calculation is valid, but the results are not showing the right percentages. I assume I wrote the formula wrong.

       

      Any help would be appreciated.  I should also include the obligatory, I'm new to Tableau...

       

      THANKS!