Ok maybe we should reduce the complexity in the first step.
Is it possible to calculate the time difference only between "Parts"?
Interruptions don't have to be considered in the first step.
Thanks for your help!
What you're trying to achieve is 'doable' in Tableau,
but i have to stress my warning message here again --
it couldn't be applied in any serious production environment,
especially with tons of machine-generated data (like yours).
Nevertheless, here it is -- using Table Calculations, of course.
The main idea is to do RUNNING calculations all through,
then capture the specific patterns in the Dimensions values
to calculate the intermediates and the final values.
Please find the attached.
Hope it could help a bit.
PS The 'ultimate' solution would be implementing the same logic
either in the DBMS of choice (using SQL-2003 compatible Window Functions),
or right in the code (of the programming language) -- the choice is always yours.
Cycle_Time_v10.2_YF.twbx 1.2 MB
thanks for your support.
The calculation works really well, great job.
Now I have the problem, that i can't do any visualisation with the calculated fields.
How can i do maybe a chart with the stations on X-axis and your calculated field YF: Datediff (Part - Begin/End)?
What do i have to do, that i can use the values you calculated in Sheet 7?
Thank you for helping!
Here is where the 'solution' complexity would take its' toll.
For Nested Table Calculation to work as expected,
one need all the necessary Dimensions on a view (somewhere).
For the simple layout you'd like to get, the [Station] is on Columns,
and all other Dimensions (three of them from the original Sheet 7)
should be on Details at least.
Besides, the Bars from the green pill on Rows should be
the size of the Total (WINDOW_SUM) values for each Station.
So one need yet another Nested Table Calc just for that.
And to leave only a single Mark for each Station on a view,
one need a Table Calculation Filter just for that.
Last but not least, one should be careful about
the proper Addressing for all the Table Calculations
(both on a view and on filters). Your case it's rather simple one.
All the (Nested) Table Calcs should have the same addressing --
along all Dimensions excluding the [Station].
Please find the attached with mods.
Cycle_Time_v10.2_mod_YF.twbx 1.2 MB