0 Replies Latest reply on Dec 8, 2018 4:27 AM by Helio Martins

    Matrix to Analyze SKU A vs SKU B

    Helio Martins

      Hello Everybody,

       

      I am developing a tableau dashboard that needs compare the average time to perform changeover in the production lines. The idea is to compare the average time to change SKU A to SKU B.

       

      I created that in excel just to help understand the problem.

      Example: This excel calculation is to: If the line changes return "SKU Posterior", If line does not change and "SKU Posterior" changes then return "SKU Posterior" -1.

       

      Is it possible to have the same calculation on Columm E (excel) in Tableau? Because it will be used in live data.

       

      Thanks in Advance!

      In Tableau it should the like that: