1 Reply Latest reply on Apr 25, 2016 12:28 PM by Sara Sparks

    Excel Offset TO Tableau..

    Ajeet ...

      Hi All,

       

      I would like to get your support on the following View

       

      :

       

      I want to create a calculated field and put it in the rows to get the following output: Look Up 1 in the Attempt % Comprehensive and give me 0 % in the calculated Field. SImilarly, Look Up 3 in the Attempt % Comprehensive and give me 100 % in the calculated Field. In addition, If TAT Field is Null the in my calculation, there should be A Value in the Cell that must be ignored in any future calc. I produced the same in Excel using OFFSET & MATCH.

       

       

      Attached is the workbook..ANy help pls

       

       

      Regards,

      Ajeet..

        • 1. Re: Excel Offset TO Tableau..
          Sara Sparks

          Hi Ajeet!

           

          You can use an IF/THEN calculation to conditionally call the measure you are looking for, as we see below:

           

          IF ATTR([TAT (Days)].[TAT]) = 1 THEN [Attempt % Comprehensive 1]

          ELSEIF ATTR([TAT (Days)].[TAT]) = 2 THEN [Attempt % Comprehensive 2]

          ELSEIF ATTR([TAT (Days)].[TAT]) = 3 THEN [Attempt % Comprehensive 3]

          END

           

          Using this calculation should get you the results that you see in Excel using the OFFSET & MATCH functions, although they aren't finding the results positionally, but rather based on the name of the fields themselves.

           

          Does this help?