1 Reply Latest reply on Sep 27, 2016 11:18 AM by Matt Hong

    Inconsistent behaviour- Tableau dynamic Color code

    Akkoli Pottammal

      Hi Team,

      we have a problem statement related with color coding in Tableau.

       

       

      Simplified sample scenario:

      We have 2 calculated fields – X & Y.

      If X > Y , we should show both fields in Green color//#ED1C24

      If X=Y ,  we should show both fields in in Orange color #FFCE06

      If X<Y, we should show both fields in in Red color #E62125

       

      Steps followed:

      1.    Click "Analysis" and select Create "Calculated Field."
      2. In the Formula text box, type the following IF and ELSEIF statement

      IF X> Y  THEN “#ED1C24

      ELSEIF X = Y  THEN “#FFCE06

                ELSEIF X<Y THEN "#E62125"

      END

       

      3) Place the calculated field on the Color shelf

       

      Expected:

      If X= 100 & Y =100

      Both X& Y should be displayed in #FFCE06” color

       

      Actual:

      If X= 100 & Y =100

      Both X& Y is getting displayed in#FFCE06” color in only certain sheets, not in all sheets .

      Problem statement

      Color code is getting reflected properly only in a certain sheets of a dashboard.

      Other Items I can see that calculation is success but color code is not getting reflected.It shows different colors

      Tableau shows inconsistent behaviour  while dealing with color codes.

       

      Colorcode.jpg

       

       

      Looking for support to fix this issue.

      Any help is appreciated.

       

      Thanks

      Akkoli