Dynamically create new variable based on differences between rows
Jun 2, 2011 11:19 AM(1696 views)
I'm relatively new to complex JMP formulas that probably involve local variables and have a question about dynamically creating and using local variables in a column formula.
I have a data series that increases or decreases over time and has several resets in the data series. The data resets are when the instrument is reset to something near its' lower measurement range.
I want to be able to adjust the data so that: 1) all data prior to a reset are unadjusted and brought over into a new column variable, 2) the first reading after a reset is set to the last data value prior to the reset, 3) the readings after the reset are the result of the difference between two adjacent rows added to the adjusted data in the previous row. This needs to be done with multiple data resets and with data that has a positive and negative slope to it.
An example of the type of data for both a positive and negative sloped data series is show below.
Any suggestions on how to accomplish this using a JMP column formula would be greatly appreciated.