3 Replies Latest reply on Aug 9, 2016 10:32 AM by Mahfooj Khan

    calculated field for many dimensions

    Muhammad Khan

      Hey Tableau Forum,

       

      Quick question.  Does anyone know how to create a calculated field for many dimensions. below are some notes.

       

      Dimensions

           1     On Job with "YES" and "No" options

           2     vacations  with "type 1" , "type 2" , "type 3" and "No" options

           3     Target achieved with  "25 to 50" % , "50 to 60 %"  and "Plus 60%"

       

      I want to calculated Bonus Eligibility for those employees who are On job , not on vacations , achieved target 50 to 60 % and  Plus 60 %.

       

      My understanding

       

           IF      [on Job] = 'yes' ,

                    [vacations] = 'No' ,

                    [Target achieved] =  '50 to 60 %' AND

                    [Target achieved] = 'Plus 60%' THEN 1 else 0.

       

      But it is not working.

       

       

      Thanks in advance

       

      Muhammad