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: