JMP User Community

Latest Discussions

Gradient: color for Missing

Is there a way to change the color of Missing entries in GraphBuilder when using a gradient?
hogi

Discussions |
Mar 23, 2023 2:40 AM

1041 views | 1 replies
Creating a formula column from a list ( JSL )

I want to create a simple formula for adding columns that are coming from a list. The list can vary in the number of elements. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Bands Data.JMP" ); col_list = {"varnish pct", "ink pct", "solvent pct" }; // expected formula (hard coded) dt << New Column( "mysum", Formula( Sum( :varnish pct, :ink pct, :solvent pct ) ) );This solution works fo...
FN

Discussions |
Mar 22, 2023 11:40 PM

1551 views | 3 replies
Script to obtain a global anomaly score ( screening outliers )

JMP has several methods to explore outliers (Analyze>Screening>Explore outliers). For a first data exploration, I am looking for a solution so the users can interactively filter all anomalous rows. One simple approach is to conduct a KNN outlier analysis (unchecking the option of imputations and being able to change the default number)

And save the distances to each NN, so a global score can be o...
FN

Discussions |
Mar 22, 2023 2:12 PM

1017 views | 1 replies
Update table error

Hi JMP community, I'm trying to update the rows from another jmp data.When I update the table, some of the row values disappear after updating (see snippet below) Original table : After updaing:Any advice or suggestion?
Jackie_

Discussions |
Mar 22, 2023 1:02 PM

1081 views | 1 replies
How to apply a script on subsets of a datatable

Hello, In my datatable I have 6 data subsets (distinguished one another by Column X where each subset has a different letter "a", "b", "c", "d", "e" and "f"). How could I apply a script to all 6 subsets independently and get the 6 results of my script in one column? Thank you in advance for your support! Best Claire ------ Script currently applied to entire datatable: dt = Current D...
cbaril

Discussions |
Mar 22, 2023 7:58 AM

1897 views | 4 replies

Previous
Next

Latest Discussions

Creating a formula column from a list ( JSL )

I want to create a simple formula for adding columns that are coming from a list. The list can vary in the number of elements. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Bands Data.JMP" ); col_list = {"varnish pct", "ink pct", "solvent pct" }; // expected formula (hard coded) dt << New Column( "mysum", Formula( Sum( :varnish pct, :ink pct, :solvent pct ) ) );This solution works fo...
FN

Discussions |
Mar 22, 2023 11:40 PM

1551 views | 3 replies
Update table error

Hi JMP community, I'm trying to update the rows from another jmp data.When I update the table, some of the row values disappear after updating (see snippet below) Original table : After updaing:Any advice or suggestion?
Jackie_

Discussions |
Mar 22, 2023 1:02 PM

1081 views | 1 replies
Script interactif

Bonjour, est-il possible sur JMP de réaliser des scripts interactifs avec l’utilisateur ? Par exemple, dès lors qu’on lance le script, JMP va nous demander par rapport à quels paramètres on veut réaliser une carte de contrôle ect... Merci de votre aide
hcarr01

Discussions |
Mar 22, 2023 7:28 AM

929 views | 2 replies
HOW to count the word as there is a column about sentence

hi, I have a question about how to count the word in a column about sentences. for example, if a participant writes "I like chocolate bars" , it would be counted as 4 words. if the sample size is 100, how can I count words in this column by each participant? best wishes, Rongyu
Rongyu_Kuang

Discussions |
Mar 22, 2023 6:40 AM

2649 views | 6 replies
DoE - Continuous factors not allowing to set the decimal format

Hello, When I try to insert a decimal number in a continuous factor of DoE: it does not allow it. It appears a huge number like the below (instead of 2.2 that I inserted. I tried with "." and "," and the result is always this): How can I solve this? Thank you in advance,Helena G.
HelenaG

Discussions |
Mar 22, 2023 3:26 AM

1245 views | 3 replies

Previous
Next

Latest Discussions

Black Cursor Keeps Turning into the Regular Windows Cursor

I am trying to hover over values to get the provided explanations, but it won't work because my mouse cursor keep changing into the regular white windows cursor. I only have the black cursor when hovering over certain things (like graphs) but I want it to be active for the entire window. Is there anyway to fix this? Edit: Nevermind, the white cursor works fine. I saw in another discussion that I j...
Shipidento

Discussions |
Mar 17, 2023 5:50 PM

1351 views | 0 replies
problème affichage date et heure dans un dashboard

bonjour, j'ai créé un dashboard avec un script. Quand je fais affiché la date et l'heure, j'ai des affichages qui varient et qui décalent mes graphiques.comment je peux supprimer ce problème dans mon script? cordialement
Françoise

Discussions |
Mar 17, 2023 4:55 AM

985 views | 0 replies
JMP17 JSL 读取多张表时值为空怎么解决？

JMP17版本用之前15版正常的读取程序，结果为空值。比如第一个表中一行是1,2,3这种值的，第二张表这一系列，是这列，ML1,R1拼接在一起，L1,R1,M1就自动改变亏值。求问大佬怎么解决？dir = Pick Directory( "Select a directory" ); //得到所有文件名，注意要确保所有表格字段名一致，且表格样式一样，否则会得到非预期结果。 files = Files In Directory( dir, Recursive ); If( Contains( files, ".DS_Store" ), files = Remove( files, Contains( files, ".DS_Store" ) ) ); For( i = 1, i <= N Items( files ), i++, fullfile = dir || files[i];...
lehaofeng

Discussions |
Mar 16, 2023 5:58 AM

698 views | 0 replies
How to get ROC table for Neural Network classification model?

I fitted Neural Network on a dataset that has nominal response variable. For logistic regression model, I can see ROC table along with ROC curve. However, in neural networks (and other ML models) I only get the ROC curve but not ROC table.
abhinavsharma91

Discussions |
Mar 12, 2023 5:58 AM

683 views | 0 replies
change font size only on the major ticks when using log scale

Hi, when using a log scale two font sizes are being used (for the major and minor ticks). How do I only change one of them (e.g. major ticks)? Any change I make seems to apply to both. In other words, I want to have the font size for 100, 1000 to be closer to that of 200, 300, 400 in the example below using JMP17.0.0
mvanderaa1

Discussions |
Mar 10, 2023 3:07 AM

715 views | 0 replies