1 Reply Latest reply on Jun 24, 2018 5:14 PM by Chris McClellan

    Tableau Conditional formatting

    Mahendra Magare

      Dear people,

       

      Trying to get below mentioned formula for conditional formatting. but result is showing as per attached file.

       

      IF ([Bucket 1-30]) <=0.02 AND

      ([Bucket 31-60]) <=0.02 AND

      ([Bucket 61-90]) <=0.02 AND

      ([NPA]) <=0.02 THEN 'Green'

      ELSEIF [Bucket 1-30] >0.02 AND [Bucket 1-30] <=0.04 AND

      [Bucket 31-60] >0.02 AND [Bucket 31-60] <=0.04 AND

      [Bucket 61-90] >0.02 AND [Bucket 61-90] <=0.04 AND

      [NPA] >0.02 AND [NPA] <=0.04 THEN 'Amber'

      ELSEIF [Bucket 1-30] >0.04 AND

      ([Bucket 31-60]) <=0.04 and ([Bucket 61-90]) <=0.04 AND

      ([NPA]) <=0.04 THEN 'Red'

      ELSE 'Black' END

        • 1. Re: Tableau Conditional formatting
          Chris McClellan

          I think you're wanting to do this:

           

          2018-06-25 10_12_51-Tableau - Branch Wise DPD.png

           

           

          then you need to do this:

           

          IF AVG([Bucket 1-30]) <=0.02 AND 
          AVG([Bucket 31-60]) <=0.02 AND
          AVG([Bucket 61-90]) <=0.02 AND
          AVG([NPA]) <=0.02 THEN 'Green'
          ELSEIF AVG([Bucket 1-30]) >0.02 AND AVG([Bucket 1-30]) <=0.04 AND
          AVG([Bucket 31-60]) >0.02 AND AVG([Bucket 31-60]) <=0.04 AND
          AVG([Bucket 61-90]) >0.02 AND AVG([Bucket 61-90]) <=0.04 AND
          AVG([NPA]) >0.02 AND AVG([NPA]) <=0.04 THEN 'Amber'
          ELSEIF AVG([Bucket 1-30]) >0.04 AND
          AVG([Bucket 31-60]) <=0.04 and AVG([Bucket 61-90]) <=0.04 AND
          AVG([NPA]) <=0.04 THEN 'Red'
          ELSE 'Black' END
          

           

          When you change the code in Con Forms you will have to drag it on to Color again.