Variable limits to graph depending on the products

Question

Hi

Thanks for reading.

Dot plots which are generated in JSL using graph builder.

I am trying to get SQL search a product column and for each product to return a reference line on a graph for the appropriate limits for that product.

Example:

If product                  Then

*                         Add reference line on graphbuilder 88 to 92
*                         Add reference line on graphbuilder 84 to 88
*                         Add reference line on graphbuilder 80 to 84

Any ideas how this could be done would be great.

Phil_Kay · Answer

Hi,

I've seen other JMP users manage this by having a column each for upper and lower limit. Then plot these as overlayed variables on the graph (uses the connecting line graph element).

In their case they had these columns in their database. i.e. the upper and lower limits are recorded with every result.

However, you could easily add these as new formula columns with IF statements to yield the different limits by product. The code for adding formula columns is pretty simple. And it could easily be added as post-query script in JMP's SQL Query Builder.

dt = Current Data Table();
dt << New Column ( "Upper",
Numeric,
Continuous, 
Formula ( If( :Product == "A",
92,
If( :Product == "B", 88, 84 )
) )
)

ian_jmp · Answer

That's easy enough to do. But the details would depend on exactly how you have the data stored, and the meta-data (limits) for each product. Maybe you can post an example JMP file?

DKI · Answer

Hi Ian

Thanks for the suggestion. This script appears to be adding lines at set values.

I am looking at something similar but I would like the values of at which the lines are placed to change conditionally on what product number the script finds in the Product collumn

i.e.

If Product 1                              then the reference lines get inserted at limit values 3 and 4

If product  2                             then the reference lines get inserted at limit values 5 and 6

I would like the quiry to esentially do a Vlookup (appologies for the excel term) and based off the values it finds to set the limits