nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help with graph builder

billi

I have data from 35 batches and would like to graph each batch and see at what time each batch had highest reading. For instance for batch 1 highest reading was 281.944 at 4.5 hours and for batch 2 highest reading was 312.314 at 5 hours (data is in the attached file). I want to plot all the batches to compare them. Is there a way to plot this?

test.jmp

Accepted answers

txnelson

What I did was to stack all of the hour columns, and then to create a new column called High, which has the value of Yes, when the row is the high for the batch and No for all other rows. I then just simply turned the labeling on for the Batch column, for the rows that have the Yes value. I have attached the stacked data table with the formula column

billi.jmp

txnelson

Attached is your data table, with a new column with the formula I provided previously. The formula works fine. The issue with the formula, is that it does not specify a "Yes" to any row, when multiple "High" values are found. If this is not what you want, then all you need to do, is to determine how from your data that you can identify which row of the multiple same value of high. Then it is a matter of putting that key into the formulal

billi T1.jmp

All comments

txnelson

billi.jmp

billi

@txnelson thank you so much for your help. This is what i needed but I do not see the attached data table with formula column. I stacked my data just wanted to look at the formula column. Thank you again for your help.

txnelson

Well, I thought I had attached it......I updated the entry, so the data table should be there now

billi

@txnelson Thank you so much for your help.

billi

@txnelson Got couple of more questions. In the attached data file, the value for all the data points is '0' so when I create variable 'high' with yes for high and no for low values it assigns yes to whole batch because for all the time points value is '0'. For example batch 7. Is there any way to fix this? Secondly, I know there is an easy to do this which I am not aware of, when I am adding label for all the 'yes' values in column high I am selecting all the yes values one by one and then select label. Can you please tell me what is the easy way to add labels?

Thank you for your help in advance.

t2 test.jmp