7 Replies Latest reply on May 21, 2018 7:18 AM by Yuriy Fal

    How to create a calculated field based on a combination of values from a single field?

    Bosmat Ivry

      Hi

       

      I am very new to tableau and trying to figure out a way to calculate a field so in the example below I could show an unstable column. If a test in a specific revision failed some of the time and passed some of the time I would like for it to appear under an "unstable" column.

      my data structure is in excel and it is pretty much like the table below.

       

      I tried:

      IF ( ([Test_Status]= 'failed') AND ([Test_Status] = 'passed')) THEN 'Unstable'

      else [Test_Status]

      END

       

      I simply got the [Test_Status] back.

      Do you have any ideas how to solve this?

      question regarding tableau.png

      Test NameExecution IDTest_Status
      Revision
      test 111111passed1.0
      test 111112failed1.0
      test 211113passed1.0
      test211114failed1.1