Comments
-
Let me try and provide some more clarity. The dataset I showed is after it goes through ETL. There are two datasets feeding the ETL. The first is one that contains date, team, act hrs, plan hrs and shift. The second contains date, team, shift, station, issue and DT. I used a left join on date, team and shift. When I do…
-
Appreciate you taking the time to create a trial dataset to show how this might work. Took me a couple tries to work it out but seems to be work so far. Thank you.
-
Thank you. Tried it and it seems to be working.