Hey everybody,
From my predecessor I inherit some data files with these kind of formulas (see also attached file):
Match( :Phase,
"Preparation", (:Date_time[2] - :Date_time[1]) / 3600,
"Cultivation", (:Date_time[5] - :Date_time[3]) / 3600,
"Harvest", (:Date_time[7] - :Date_time[6]) / 3600
)
I would like to exchange the row numbers with dedicated Timepoints, so that it doesn't matter at what row of the table the data is.
In my head it looks like: "Cultivation", (:Date_time[:Timepoint == "End"] - :Date_time[:Timepoint == "Inoculation"]) / 3600
Unfortunately this doesn't work and I don't find any suitable code. Can you help me with it?
Thx,
Markus
PS: as I am new to Scripting in general and JMP in special, please excuse me if I use the wrong language or ask stupid questions.