I have a simple one in illustration, but tough to implement for my level.
In the attached, I have a very simple data set of phases a vehicle goes through, Stations 1 - 3.
If an issue is raised at a station, it is categorized as Uncontained.
If a raised issue has a solution identified at the station, it is categorized as Contained.
if a raised issue is resolved at a station, it is categorized as closed.
At each station, for Closed issues, I would like to keep it where it closed out.
So in the sample, Station 1 had 1 Uncontained 1 Contained and 1 Closed.
Station 2 had 1 Uncontained 1 Contained and 1 Closed
Station 3 had 1 Uncontained 1 Contained and 1 Closed
uniquely to each station.
As the issues go through the different stations theyre categories will change and I do not want to duplicate the results for when an issue was resolved (closed out).
I hope my explanation and desired results work?
Thanks in advance Team!