topic Re: Select issue in Discussions

Select issue

DamionSparhawk — Fri, 26 Oct 2018 03:37:44 GMT

I create a graph, and when I go to select a portion of it, it highlights the entire excel sheet. I remember from demo that you should be able to select a segment and have it only highlight the data directly relating to that segment. What am I doing wrong here?

I would also like to know if there is any way to have JMP find the peak data from multiple points on the same line and display them in the graph?

Thank you for your time

Re: Select issue

txnelson — Fri, 26 Oct 2018 06:12:19 GMT

Below is a chart that has had some points selected, and as can be seen on both the chart and the data table, which points have been selected. However, you will need to provide more information about exactly what chart you were using, and what the data table contains for one to attempt to determine what the issues may be. I suggest as your first step, that you read the Essential Graphing book provided with the install of JMP

Help==>Books==>Essential Graphing

Concerning your second question, yes you could determine selected points from a line, and have their values be displayed on the chart. This can be done by specifying what columns should be used for the label, and then selecting the data points to be displayed. Again, this is covered in the Essential Graphing book

Re: Select issue

DamionSparhawk — Fri, 26 Oct 2018 07:03:26 GMT

It's a fairly simple graph with only two lines of data, it should be really simple but for some reason as you can see selecting just the peak highlights the entire spreadsheet.

The second part I'm looking more for a way to script it into the script I currently have, if I have to hunt down the data points and select them the point is already defeated, variables I know is the column it occurs in, that there will always be a 0 before each peak of reference, and that I only care about the highest point of the peak for each occurance on the line.

I'll take a look at the book of course, but time waits for no man and the purpose of this project is to streamline the tasks we already do, don't need JMP to hunt for values we already have in Excel, ya know ^.^

Re: Select issue

dale_lehman — Fri, 26 Oct 2018 11:53:42 GMT

That's interesting - the same thing happens for me. I also notice that the lasso tool turns into a rectangle rather than a free-drawing polygon. But it only happens if the line option in Graph Builder is chosen rather than the points. I am guessing that with the line drawn for the mean of that variable, all points are highlighted because all the points are used to calculate the mean - but that is a guess and I'll be interested to see if someone can unravel the mystery. As for your other question, can you use some combination of ColMax and/or ColRank functions to get the points you are looking for?

Re: Select issue

Chris_Kirchberg — Fri, 26 Oct 2018 16:01:51 GMT

Hi All,

Selecting a line will select all points that make up that line. You would have to have points on the line in order to only select that region of the line.

Hope That helps.

Chris

Re: Select issue

DamionSparhawk — Sat, 27 Oct 2018 04:01:46 GMT

Well that answers the question, but presents a new problem. On the other hand now I know a really quick way to find the peak value without a lot of effort, however I would really like to be able to just select the segment of the line. The line graph is the best way to represent the data in this case because it's fluid flow, we collect data points along a timeframe, but the fluid is still flowing between those points, and also because it mirrors the way it's displayed in other formats so it's easy to see if you're looking at the right data, or if the data is significantly out of desired parameters. I wonder if there's a way to display it as a line, but treat it as points... *ponder* Well, anyway thanks for the information!

Re: Select issue

DamionSparhawk — Wed, 31 Oct 2018 21:21:45 GMT

Addendum:

Okay, so I've modified my graph so it is also using points. However the points are enormous and clunk up my picture. Is there a way to graph the points smaller or even graph them but remove the visible points? I don't need the points, I just need the ability to select the specific segment of a line which doesn't let you do that. Thank you for your additional help!

Re: Select issue

txnelson — Wed, 31 Oct 2018 21:47:38 GMT

If you right click on the points in the graph's legend, you can change the size of the points, and the color of the points.

Re: Select issue

DamionSparhawk — Wed, 31 Oct 2018 22:32:35 GMT

Beautiful, now we're getting somewhere, I'm having trouble inserting the dialogue that comes up for that into my script. When I make that adjustment the script looks like this

but I'm having trouble figuring out where and how to insert the modifiers into my base script.

I'd love to better understand this, but understanding is less important than effect, for the moment ^.^ (saved as images instead of text because text was working strangely, text code to follow)

dt = Open ();

col_list = dt << get column names(string);

remove from(col_list, 1); // Remove time[sec] from list

cols_to_plot = {};

offset_list = {};

offset_cols = {};

// Define the graph builder commands in an expression for use by the OK button

graph_expr = expr(

for (i = 1, i <= nitems(cols_to_plot), i++,

new_name = cols_to_plot[i] || "-Offset";

insertinto(offset_cols, new_name);

dt << new column(new_name, Numeric, "Continuous", Format( "Best", 12 ),

Formula( as column(dt, cols_to_plot[i]) * offset_list[i] ) );

);

// Now for the graph - build a text string and then execute it

gb_text =

"\[gb = graph builder(

show control panel(0),

variables(

X( :Name( "Time[sec]" ) ),]\";

elements_txt = " ),

Elements( Line( X, ";

for (i = 1, i <= nitems(cols_to_plot), i++,

if (i == 1,

// then

gb_text = gb_text || evalinsert("\!N\[ Y( :Name( "^offset_cols[i]^" ) ), ]\");

// else

gb_text = gb_text || evalinsert("\!N\[ Y( :Name( "^offset_cols[i]^" ), Position( 1 ) ),]\");

);

elements_txt = elements_txt || evalinsert("Y ( ^i^ ), ");

);

elements_txt = elements_txt || "Legend( 7 ) ), Points( X, Y, Legend(8))

,";

gb_text = gb_text || elements_txt || ") )";

eval(parse(gb_text));

);

nw = new window("Graph Chemicals",

panel box("Select channels to graph",

lineup box(ncol(2),

text box("Column"), text box("Offset"),

cb1 = checkbox("Ch1"), ch1_neb = number edit box(),

cb2 = checkbox("Ch2"), ch2_neb = number edit box(),

cb3 = checkbox("Ch3"), ch3_neb = number edit box(),

cb4 = checkbox("Ch4"), ch4_neb = number edit box(),

cb5 = checkbox("Ch5"), ch5_neb = number edit box(),

cb6 = checkbox("Ch6"), ch6_neb = number edit box(),

cb7 = checkbox("Ch7"), ch7_neb = number edit box(),

cb8 = checkbox("Ch8"), ch8_neb = number edit box(),

cb9 = checkbox("Ch9"), ch9_neb = number edit box(),

panelbox("Actions",

hlistbox(

okb = button box("OK",

if (cb1 << get(1),

insertinto(cols_to_plot, col_list[8]);

offset_value = ch1_neb << get;