1 Reply Latest reply on Jan 3, 2019 6:53 AM by tian.yang.4

    Average Overall Satisfaction

    Alec Cham

      Hello all,

       

      Here is the data:

       

      ID | Price Satisfaction | Place Satisfaction | weight

      1 | 1 | missing | 5.231

      2 | 0 | missing | 2.157

      3 | 1 | 1 | 1.234

      4 | 1 | 0 | 2.888

       

      How to calculate in Tableau to find the average Overall Satisfaction? Overall Satisfaction = (Price Satisfaction % + Place Satisfaction %) / 2

       

      Thanks!!!