JMP User Community

Latest Discussions

Regex: can't get all parts of the string that match

I'm trying to extract all the parts of the string that match, but I'm using regex match and I can't get the "BWA005, BWAZ006" that I want.ex="Select Where( :\!"BWA\!"n == \!"BWA005\!" | :\!"BWA\!"n == \!"BWAZ006\!" )"; Regex match( ex, "[\!"](BWA|BWAZ|BWAZ_)([0-9]{1,})(.*?)[\!"]" )
lehaofeng

Discussions |
Apr 13, 2024 12:11 PM

5545 views | 6 replies
How to evaluate a column bottom to top?

I need to count negative indexes from a particular cell, how you make a single column evaluate bottom to top? Col 29 Col 310 -50 -40 -30 -20 -11 -421 -411 -40 If( Lag( :Column 29, -1 ) == 1 & :Column 29 == 0, -1, Lag( :Column 31, -1 ) - 1 )
zathe

Discussions |
Apr 11, 2024 8:33 AM

1426 views | 2 replies
Response Limits with if condition

Hallo Community, I try to set column properties to draw always a line in my Charts. (Target Value)But I use in my script the same Chart again for another Label. So I try to skript 2 Response Limits but it doesn't work.Is it possible to do it like this? Or is there any other Option? Data Table( "Data1" ):"KM/MA"n << Eigenschaft festlegen( "Response Limits", If( :Firma_Job == "A", {Goal( Maximize...
voy-voy

Discussions |
Apr 11, 2024 4:16 AM

1006 views | 1 replies
Is there an equivalent function to excel's BETA.INV() in JSL?

I'm trying to calculate confidence intervals with the following formula that I use in Excel: =BETA.INV(alpha/2, x, y -x +1) I can't seem to find an equivalent function in the scripting index so am not sure if one exists. Any help is appreciated.
iamericha

Discussions |
Apr 10, 2024 10:10 AM

2476 views | 4 replies
Markers

Hello I would like to do marker "full" square by rowActually, I see it works, but I'm getting frame square.How do I get a full square?wafer_dt << Select Rows << Select where (:"UNIT_STATUS" == "pass") << Colors ("Light Green") << Markers("square"); I found the code and it is marker 15, but the number doesn't work
Dennisbur

Discussions |
Apr 10, 2024 6:18 AM

1051 views | 1 replies

Previous
Next

Latest Discussions

How to evaluate a column bottom to top?

I need to count negative indexes from a particular cell, how you make a single column evaluate bottom to top? Col 29 Col 310 -50 -40 -30 -20 -11 -421 -411 -40 If( Lag( :Column 29, -1 ) == 1 & :Column 29 == 0, -1, Lag( :Column 31, -1 ) - 1 )
zathe

Discussions |
Apr 11, 2024 8:33 AM

1426 views | 2 replies
Response Limits with if condition

Hallo Community, I try to set column properties to draw always a line in my Charts. (Target Value)But I use in my script the same Chart again for another Label. So I try to skript 2 Response Limits but it doesn't work.Is it possible to do it like this? Or is there any other Option? Data Table( "Data1" ):"KM/MA"n << Eigenschaft festlegen( "Response Limits", If( :Firma_Job == "A", {Goal( Maximize...
voy-voy

Discussions |
Apr 11, 2024 4:16 AM

1006 views | 1 replies
JMP Application builder - Save preference option for user

Hi all, I have created a jmp app using the application builder. I want to know if there is any possibillity to have ''Save Preference'' option for the user in the developed application. To give context i want user to save a preffered directory to export. if user selects a directory i want to use that as default directory whenuser accesses this application again. is it possible to use that value ov...
ComplexNerd

Discussions |
Apr 9, 2024 12:42 AM

1047 views | 1 replies
Plot only the filtered data from a given column on a dashboard

Hi,I am trying to build a dash board that will plot relevant graphs.My current issue is that it plots the entire data on one graph, highlights the filtered data and the rest is grayed out. I want to graph to be build only with the data of the relevant rows of the given column.
For example, if I want to plot height as a function of age, and I have a column for "sex" which holds 'M' and 'F', so I ha...
Avshish

Discussions |
Apr 6, 2024 8:14 AM

1887 views | 4 replies
JMP16 HTML + Local Data Filters versus JMP18

There's a bug in JMP 16 under certain conditions when you save HTML graphs that use a local data filter. I found the fix where you have to Show Modes and then uncheck Include. But that doesn't work in this situation: Create two graphs, from different tables, each with their own local data filter.Combine them into a window using new window, on separate tabsSave as Interactive HTML with dataThe ...
pmroz

Discussions |
Apr 5, 2024 3:21 AM

1951 views | 4 replies

Previous
Next

Latest Discussions

Project ignoring H Splitter Box Set Sizes . . . sometimes

I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

709 views | 0 replies
Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
sm3001

Discussions |
Mar 21, 2024 12:49 AM

931 views | 0 replies
DataTable Prompt in application builder on module load

Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

662 views | 0 replies
JMP Project Global Data Filter and Column Switcher

Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
ComplexNerd

Discussions |
Mar 7, 2024 12:10 AM

621 views | 0 replies
"If" returns error response

I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl...
LT

Discussions |
Mar 4, 2024 8:08 PM

941 views | 0 replies