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: