I need an alert column that notifies me if the previous 3 week instances for a job have the same flag.
I have multiple run times for a job in a given week but I only care about the run time median for that week for that job to set my flag.
If a week of data is missing from a job I want to just default to using the previous weeks flag.
This will be used to help alert me if a process has shifted in run time.
Basically if I have 4 consecutive flags I want to have an alert.
Data set with columns that should be flagged (https://i.sstatic.net/V0fNvY9t.png)

I have a data set with hundreds of jobs over a year time frame with the date it ran and the run time.
Each job has a run time and I’m trying to detect drifts when they occur by work week.
So if I have 4 consecutive weeks where the week median is above or below the overall median for the year I need to flag it. I created a week column and a median of run time by week over the job and week column and a flag column to highlight if that week’s median run time was over the median. But as far as flagging if previous 4 weeks contain same flag for that job by unique work week I cant figure out.
Sample Data Set: (https://i.stack.imgur.com/DFRuS.png)