JMP User Community

Latest Discussions

How Formula works in New Column Function

dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); New Column("Sum", "Numeric", "Continuous", Set Formula(If(Row() == 1, :Height, Lag(:Sum,1) + :Height)) ); The code above creates Sum column with calculated the accumulative sum. I am new to JSL so could someone explain me how the Formula command works. Is it scan one by one row in the column so that we can write :Height instead of constructing a For-loop ...
hmm

Discussions |
Sep 12, 2023 4:33 AM

1008 views | 1 replies
Transform Column: Bug with excluded rows

In the below example, I use a Data Filter to restrict the data - and a Local Data Filter inside the GraphBuilder Script is used to further restrict the data. 3 different Ranks are plotted:The fist Rank (blue points) doesn't have an Excluded() argument and therefore all data points are counted - even ones which are excluded by the (global) Data Filter. This is why the first plotted entry already s...
hogi

Discussions |
Sep 12, 2023 4:31 AM

1417 views | 2 replies
Formula and graphbuilder

Dear Community, I need your help and I would like to apologize if it is a stupid question. I’m struggling with the graphbuilder.I would like to use a column including a formula option for plotting it in the graphbuilder window.Nevertheless, it only works when all the parameters are included in the formula (the two following pictures). When I try to make my formula “flexible” with a link to other c...
BigShaftie

Discussions |
Sep 12, 2023 3:04 AM

1734 views | 4 replies
JSL coloring single element of legend to a custom color

Hi all, I am trying to fix the coloring of my variability chart. I create the variability chart and then use the row legend to create a legend for the column dose. I am trying to color the label "control" the color black through JSL code. How is this possible. I have tried many combinations but my JMP 16 doesn't seem to color anything differently. Any help would be appreciated to get it like the ...
neelsrejan

Discussions |
Sep 11, 2023 10:00 PM

1920 views | 4 replies
Looping through rows of a column to find the overall count

Trying to find the number of counts of current entry in a column. The below function works but seems to be slow. Any suggestions to improve the script run time?JMP14, JMP16<For each row(Print(Col Number( :ColName, :ColName )))> My proposal: I think initially constructing Associative Array by adding the entries from the :ColName as "Key" and increasing the value (Value++) when duplicate entry i.e. ...
PredictorRoot52

Discussions |
Sep 11, 2023 4:37 PM

2212 views | 5 replies

Previous
Next

Latest Discussions

How Formula works in New Column Function

dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); New Column("Sum", "Numeric", "Continuous", Set Formula(If(Row() == 1, :Height, Lag(:Sum,1) + :Height)) ); The code above creates Sum column with calculated the accumulative sum. I am new to JSL so could someone explain me how the Formula command works. Is it scan one by one row in the column so that we can write :Height instead of constructing a For-loop ...
hmm

Discussions |
Sep 12, 2023 4:33 AM

1008 views | 1 replies
Formula and graphbuilder

Dear Community, I need your help and I would like to apologize if it is a stupid question. I’m struggling with the graphbuilder.I would like to use a column including a formula option for plotting it in the graphbuilder window.Nevertheless, it only works when all the parameters are included in the formula (the two following pictures). When I try to make my formula “flexible” with a link to other c...
BigShaftie

Discussions |
Sep 12, 2023 3:04 AM

1734 views | 4 replies
Dataset normalization in jmp 17

Can anyone please help me figure out how to access the various dataset normalization tools in JMP 17? I couldn't find any detailed explanation in the ebook "Genomic Analysis with JMP Pro". JMP Genomics had all the various normalization tools for both array and RNAseq datasets. Thank you.
Manny_B

Discussions |
Sep 11, 2023 9:53 AM

1083 views | 1 replies
To automate the Mulitple Data table selection while running Add-Ins.

Dear All,I am facing a small challenge to implement the Dashboard via Add-Ins. I have a JMP script to import the test data into different Data Table and to make plots for them. I have succeeded in creating an Adds-Ins to create a Dashboard out of the Plots from different Data Tables, however as it involves many Data Table it prompts a menu to select the corresponding Data table to create the Dashb...
SSMann03

Discussions |
Sep 11, 2023 7:47 AM

2515 views | 2 replies
How to dynamically set auto y-axis scale as parameters are selected in local data filter for (graph builder) charts by variable?

This script below generates data in a format similar to my actual data and then plots charts in a layout I would like.Multiple parameters are plotted in the y-axis as they are selected in the local data filter. This is useful for me as I can compare trends on related parameters in my actual data.Without using Graph builders "Page" option or creating additional columns in the data table, is there a...
Neo

Discussions |
Sep 11, 2023 5:33 AM

1363 views | 2 replies

Previous
Next

Latest Discussions

Discrete Choice Experiment: Prohibited Combination

Hi everyone,I would like to design my first DCE. I am going to use 6 attributes that differ in the levels from 2 to 4 levels. However, I have a limitation where there is an impossible combination that may appear; for example, the cheapest product would not be possible to have the best feature. Is there any way for me to select the prohibited combination? Or, is the D-optimal design will always cal...
andikawp

Discussions |
Sep 6, 2023 7:11 AM

704 views | 0 replies
Multivariate Analysis

Using Multivariate Analysis to study the pattern of any specific issue (e.g. water consumption of different states in a country). From T2 plot for abnormal observations we get contribution plot that shows which states are highest contributor. The Contribution plot here shows only the name of contributors. If it possible to indicate in numeric value [How much water each state is consuming]?
Chitranshu

Discussions |
Sep 4, 2023 3:01 AM

638 views | 0 replies
PickFile() from within a Project does not use file filters

When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...
R2OKeefe

Discussions |
Sep 3, 2023 8:45 PM

1020 views | 0 replies
Cannot get Virtual Lab to run well on iPad. IPad on iOS 17

The option to go to fonts aA to run in mobile mode just spins and spins. Cannot get Citrix in the regular mode to work well, freezes, etc, especially when switching screens. Trying to take the online course with video & Virtual Lab. JMP version on Citrix is 17
Bbrown

Discussions |
Aug 30, 2023 12:53 PM

660 views | 0 replies
bivariate normal distribution

How can I draw a bivariate normal distribution in JMP?Are there any tests for determining the multivariate normal distribution in JMP?
A-Ebrahimi

Discussions |
Aug 26, 2023 7:49 AM

624 views | 0 replies