JMP User Community

Latest Discussions

Bar charts with two Y-axis

Hello everybody, I am trying to make a bar chart with two Y-axis. This post https://community.jmp.com/t5/Discussions/Graph-Builder-how-to-do-2-Y-Axis-s-left-and-right/m-p/38327#M22435 helped me to make a secondary axis, however now the struggle is to make bars for both the sets of values. Hope someone know how to do this, as this is tricky in Exel too. Thanks!
therese

Discussions |
Nov 14, 2018 6:23 AM

5265 views | 2 replies
How to replace "." or "-" character to "/"

Hello,I started a script that imports multiple excel files into one table. The date field has a mix of formats; mm/dd/yyyy , mm.dd.yy and mm-dd-yy.I tried using recode, and looking at the script it looks like static values:Current Data Table() << Begin Data Update; dc1 = New Column( :Date ); dc1 << Set Name( "Date 3" ); Current Data Table() << Go to( dc1 ); Current Data Table() << Move Selected Column...
Herrera5238

Discussions |
Nov 13, 2018 2:37 PM

3258 views | 1 replies
Concatenate table values into a string variable

I have a table of characters and want to produce a string variable of the concatenated values of each column to use as the argument of a function. Let's say this is my table of data:Column1 Column2Item1 Value1Item2 Value2Item3 Value3Item4 Value4Item5 Value5 . . . . . . The table will have 2 columns but any number of rows. The output I'm looking for is thi...
RonSwanson

Discussions |
Nov 13, 2018 11:20 AM

5402 views | 4 replies
Local data filter

Control Chart( Sample Label( :C_LOT_NAME ), Group Size( 1 ), KSigma( 3 ), Chart Col( :Average Pigment Strength, Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ), Capability( Distribution( Automatic Recalc( 1 ), Continuous Distribution( Column( :Average Pigment Strength ), Quantiles( 0 ), Summary Statistics( 0 ), Outlier Box Plot( 0 ), Normal...
ChrisNally

Discussions |
Nov 13, 2018 7:26 AM

6069 views | 7 replies
Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Please excuse my naive question.I have a large dataset from a temperature logger which is sampling several times per second. I would like to format the time column to be able use the milliseconds data. Further, in other data, Durations and Times may include milliseconds, nanoseconds, microseconds etc, but I can see no way to format the column appropriately in JMP so that these values may be used...
matthew_gill

Discussions |
Nov 12, 2018 5:38 PM

13742 views | 3 replies

Previous
Next

Latest Discussions

Bar charts with two Y-axis

Hello everybody, I am trying to make a bar chart with two Y-axis. This post https://community.jmp.com/t5/Discussions/Graph-Builder-how-to-do-2-Y-Axis-s-left-and-right/m-p/38327#M22435 helped me to make a secondary axis, however now the struggle is to make bars for both the sets of values. Hope someone know how to do this, as this is tricky in Exel too. Thanks!
therese

Discussions |
Nov 14, 2018 6:23 AM

5265 views | 2 replies
How to replace "." or "-" character to "/"

Hello,I started a script that imports multiple excel files into one table. The date field has a mix of formats; mm/dd/yyyy , mm.dd.yy and mm-dd-yy.I tried using recode, and looking at the script it looks like static values:Current Data Table() << Begin Data Update; dc1 = New Column( :Date ); dc1 << Set Name( "Date 3" ); Current Data Table() << Go to( dc1 ); Current Data Table() << Move Selected Column...
Herrera5238

Discussions |
Nov 13, 2018 2:37 PM

3258 views | 1 replies
Concatenate table values into a string variable

I have a table of characters and want to produce a string variable of the concatenated values of each column to use as the argument of a function. Let's say this is my table of data:Column1 Column2Item1 Value1Item2 Value2Item3 Value3Item4 Value4Item5 Value5 . . . . . . The table will have 2 columns but any number of rows. The output I'm looking for is thi...
RonSwanson

Discussions |
Nov 13, 2018 11:20 AM

5402 views | 4 replies
Local data filter

Control Chart( Sample Label( :C_LOT_NAME ), Group Size( 1 ), KSigma( 3 ), Chart Col( :Average Pigment Strength, Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ), Capability( Distribution( Automatic Recalc( 1 ), Continuous Distribution( Column( :Average Pigment Strength ), Quantiles( 0 ), Summary Statistics( 0 ), Outlier Box Plot( 0 ), Normal...
ChrisNally

Discussions |
Nov 13, 2018 7:26 AM

6069 views | 7 replies
Exporting data from jmp to excel without excluded rows

Hi, Is there any add-in for jmp that helps exporting data to excl without exclueded rows? Thanks,Ne
NeF

Discussions |
Nov 9, 2018 1:52 AM

7500 views | 4 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2596 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3253 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3680 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2511 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3509 views | 0 replies