Data Manipulation - How do I remove Initial Offsets specific to a col identifier
Apr 19, 2019 7:50 AM
| Last Modified: Apr 19, 2019 7:51 AM(3982 views)
My first post! I have a regular set of data I process and have been doing manual manipulation in excel before importing and plotting in JMP. I'm sure someone has a better way :)
I measure 16 DUT's and record offset data for each dut. I would like to zero out each individual DUT offset based on the first 100samples of data and apply this to all rows of data.
I would like to remove the initial offset based of "X_" on average of say the first 100 rows. This offset is unique to each DUT identified in COl "DUT#".
Is there a slick way of doing this via formula or built in scripting options?
My manual method is to split table by DUT, create 16 new cols, subtract an average of the first 100 data and then restack it.
I have attached the plot and .jmp table showing raw data plotted without the intiial offset being removed.
Ultimately I want to see the relative change over time hence removal of the intiial offset!
One other challenge is in dealing with the Date / Time cols. Note I plotted Time / Date, ideally I would like to calculate the time in hours starting from zero to the end of dataset and plot from zero to say 85hours on the X Axis of this plot. I'm struggling to manipulate this using the formula!
Any help appreciated to make my day more productive!!