Row Device Time Performance 1 T1 0 97 2 T2 0 93 3 T3 0 95 4 T1 100 83 5 T2 100 82 6 T3 100 83For the relative performance, I setup a formula script
perf_0 = match (Device, "T1", Performance, "T2", Performance, "T3", Performance); Performance / perf_0This works well with a limited number of data points, but is prone to typing errors for large data sets. Is there a better way to have this automated and less prone to errors? Note that the Performance value at time 0, is not necessarily the maximum or minimum value.
Solved! Go to Solution.
As you've intuited, there are probably better ways to do what you intend.
I would recommend a script with an Associative Array. Please reference the Scripting Guide, and the JMP mockup of your dataset and an example of a script enclosed.
Hi all, I have the same question. However, I need a more reliable solution, I mean, not relying on row number, as my sheet can be mixed up.
So, is there a way to get the value from :performance of the row having the lowest value in :Time for each device, or even better: the value corresponding at Time=0 for each Device...
Maybe I'm not that clear...
Here is a formula that will work. I have also attached a data table with it applied.
dt = Current Data Table(); currentDevice = :Device; :Performance / :Performance[(dt << get rows where( :Device == currentDevice & :Time == 0 ))];