8 Replies Latest reply on Aug 31, 2017 6:43 AM by T G

    Help with creating a calculation field

    Imran Azam

      Hi guys

       

      I do not  know if this can be done in a tableau ,calculation, I have the data below ( this is example data)

       

      server

      location 1

      location 2

      test

      A

      north

      north

      1

      A

      west

      null

      2

      B

      west

      west

      1

      B

      north

      north

      null

       

      I am trying to create a calculation that will do the  following  - If the server = A and , location 1 and  location 2 are the same then YES, If server=
      B and test = 1 than Yes Else no. ( please note The location 1 & 2 will either match or one will be null)

       

      So it should bring back the below

      server

      location 1

      location 2

      test

      A

      north

      north

      1

      B

      west

      west

      1

       

      Can this be done?

       

      Am I making any sense?