2 Replies Latest reply on Jul 3, 2018 11:09 AM by Bhargav Kommineni

    Calculated Fields using Filters

    Jonathan Chase

      I am trying to allow the people to use filters to determine a final calculation there are 3 groups of data.

      Impact, Likelihood, and Control factor

      The result needs to be (Impact * Likelihood)*Controlfactor

       

      Example

      Impact = High = 5

      Likelihood = Likely = 5

      Controlfactor = Marginal = 1

      (5*5)*1=25

       

      I can get Tableau to work if each filter is in the same position but when you move from the top to the next option in filter it stops working attached is the Twb I am using.