1 Reply Latest reply on Aug 7, 2017 6:40 PM by Shinichiro Murakami

    Calculate a new field based on factor that  is in a matrix chart

    mozammel chowdhury

      I am attaching two files labeled "main" and "ReverseTriangle" . Following is what I am trying to accomplish

       

      I am trying to setup a logic to calculate a new field called "Adjusted Profit" that is the result of the field Proft * The factor from the file "Reverse triangle" .

      The factor will be chosen based on the "Project duration in Weeks" and the "week".

       

      So if the project duration is 29 weeks looking at the "Reverse Triangle matrix" the factos for week 10... week 19 is as follows:  Please let me know if you need additional wexplanations to build something in tableau for this.

      Thanks

       

       

       

                   0.039
                   0.044
                   0.051
                   0.056
                   0.058
                   0.060
                   0.061
                   0.062
                   0.061

                   0.058