4 Replies Latest reply on Nov 28, 2016 12:14 PM by Matthew Risley

    Making A Better Calculation

    Matthew Risley

      Hey Tableau community!

       

      I have a calculation that works, But I'd like to make it better.

      The calculation is OSAT (Overall Satisfaction). There are multiple different questions in a survey that capture OSAT for different products. Each product's OSAT is a column in my data set. OSAT is based on values of 1-10.

       

      The standard OSAT calculation is   %9's and %10's ÷  Total Responses

       

      Here is how I calculate it so far:

                                                        - I add up the 9's and 10's

                                                        - Divide that by the count

       

      I have many OSAT questions and making two calculated fields for each one seems tedious. However, I am prepared to do so.

       

      Is there a way to do this within one step (ie. One calculated field) ?

       

      Thanks!