2 Replies Latest reply on May 3, 2018 9:07 AM by Matt Huff

    % Difference problem

    Matt Huff

      Pretty much new to Tableau and I am in need of some help.  I can't attach my workbook because of privacy issues, but I exported the fields in question into excel which is attached.  If there is a better way please let me know so it's easier for you to help.

       

      What other information do you require for help? 

       

      Here is a screen grab of what I will eventually need:

        • 1. Re: % Difference problem
          Shinichiro Murakami

          HI Matt,

           

          Could you clarify what is the issue and what is the expected results?

           

          Thanks,

          Shin

          • 2. Re: % Difference problem
            Matt Huff

            Yes my apologies.  In the spreadsheet under the order code column there is a percentage.  That is the percentage that Tableau derived using the '% difference from'. 

             

            To the right of that the column labeled '% diff compared' is the calculated % difference that I did using the Avg. Day_turnaround_time. 

             

            The problem is that they don't match when they should and I know I am probably doing something wrong within tableau, but can't figure it out.

             

            Here is a screenshot of the table calc:   The 29.2% should be 25.5% as an example.