1 Reply Latest reply on Aug 24, 2016 12:39 AM by Shriram Saxena

    List report coloring pane background instead of measures values on Adhoc basis.

    Maheshh C K

      Dear Team,

       

      I have an requirement in Tableau to color the pane based on the values in a list report.

      I tried coloring the same but was successful only till coloring the measure value. Am a newbee in tableau. Kindly help me on the same.

      Attaching the .twbx file for the reference.

       

       

      Input:

      Entity
        Name

      Limit1

      Limit2

      Limit3

      Measure Date

      Value

      Enitity1

      5

      10

      15

      24/8/2016

      8

      Enitity1

      5

      10

      15

      25/8/2016

      13

      Enitity1

      5

      10

      15

      26/8/2016

      18

      Enitity2

      5

      10

      15

      24/8/2016

      8

      Enitity2

      5

      10

      15

      25/8/2016

      13

      Enitity2

      5

      10

      15

      26/8/2016

      18

       

      Color Logic:

      IF
      [Value]<[Limit2] THEN "Green"

      ELSEIF
      [Value]<[Limit3] THEN "Yellow"

      ELSE
      "Red"

      END

       

      My current Result:

      Entity
        Name

      Limit1

      Limit2

      Limit3

      24/8/2016

      25/8/2016

      26/8/2016

      Enitity1

      5

      10

      15

      8

      13

      18

      Enitity1

      5

      10

      15

      8

      13

      18

       

      Expected Result:

      Entity
        Name

      Limit1

      Limit2

      Limit3

      24/8/2016

      25/8/2016

      26/8/2016

      Enitity1

      5

      10

      15

      8

      13

      18

      Enitity1

      5

      10

      15

      8

      13

      18

       

      Thanks

      Maheshh