How can I streamline my formula to relabel a time series?

Question

I have a dataset of measurements taken before and after a process transition for ~300 machines.

* The number of days before and after a transition varies
* The transition can happen on different Days

I inserted a formula that would label 3 days on either side of a transition day so I can select an idendical sample size for each of the 300 machines.

If(
	Lag( :Condition, -3 ) == "Transition", "1",
	Lag( :Condition, -2 ) == "Transition", "2",
	Lag( :Condition, -1 ) == "Transition", "3",
	:Condition == "Transition", "Transition",
	Lag( :Condition, 1 ) == "Transition", "4",
	Lag( :Condition, 2 ) == "Transition", "5",
	Lag( :Condition, 3 ) == "Transition", "6"
)

Which gives what I was hoping for

Using if statements like that feels...hacky.  Can anyone think of a more elegant way to do this?

jamiesupica0 · Answer

Thanks Dale, I didn't realize you could use a period for Null.

dale_lehman · Answer

I don't think this is any simpler - but it was better than making a New Year's resolution.  You might find something in here that you can use, however.  Attached is my version.

Sample.jmp