JMP User Community

Latest Discussions

How do I create a new data table combining duplicate rows?

I have a indexed list of production runs of different products (A-H) and their start and end times. Sometimes there are two lines in a row with the same product (rows 1 & 2 and 7 & 8) and I would like those to be combined into one row with the start time of the first row and end time of the second row. How would I use JSL to do this?
gmc5149

Discussions |
Apr 18, 2024 10:17 AM

2316 views | 3 replies
Quick way to populate many correlation coefficients in to a column at once?

I have a dataset with five sample dose levels and many compound concentrations identified in the samples. I would like to see which of the compounds correlate with the sample levels and sort the compounds by most correlated. I think the easiest way would be to batch-run regressions and have the Pearson correlation coefficient or r squared populate to a data table, but I'm not sure how. Would I hav...
Mcc99

Discussions |
Apr 17, 2024 1:02 PM

2490 views | 2 replies
freeze H List in the report

Hi community, i am wandering if the following is possible in JSL I have a V list that includes two columns1. Filter window in the Data2. Hlist with many charts the charts require me to scroll right to review them all i would like to conitnue to see the filter window even if i scroll far to the right (sort of like freeze columns in Excel, so the wanted column will be seen all the time) Is this pos...
Buldozer

Discussions |
Apr 17, 2024 12:40 PM

1914 views | 2 replies
Col Cumulative Sum without calling the current row's value

Hello, I am quite new to writing JMP scripts and primarily use "Edit Formula" for my work. I have been browsing solutions related to Col Cumulative Sum and could not find one for my specific problem. The simplified version of my data table is as follows. RowWeekCol Cumulative SumMy Wish11102231336344106551510662115 The formula below works if the current row value of "Week" is fixed or if I have tw...
tMinnx

Discussions |
Apr 17, 2024 9:43 AM

11203 views | 15 replies
What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

DL

Discussions |
Apr 17, 2024 4:50 AM

950 views | 0 replies

Previous
Next

Latest Discussions

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

DL

Discussions |
Apr 17, 2024 4:50 AM

950 views | 0 replies
Graph builder - reverse Y scale (only)?

How can I reverse the Y scale in Graph Builder when using Shape files?Unfortunately, Graph Builder( Size( 545, 458 ), Summary Statistic( "Median" ), Graph Spacing( 4 ), Variables( Color( :"Y-Pos"n ), Shape( :Shape_Name ) ), Elements( Map Shapes( ) ), SendToReport( Dispatch( {}, "", ScaleBox( 2 ), {Reversed Scale} ) ) )doesN't have an effect - and with in the GUI the X Scale gets reverse...
hogi

Discussions |
Apr 17, 2024 2:27 AM

2176 views | 3 replies
Problem with Opening file (tried to make it a flexible dt name in JSL)

Names Default To Here(1); //Open Data Table: Recovery_Analysis:Plate Name.jmp Recovery_Analysis:Plate Name = Open("MY FILEPATH"); //Split data table Recovery_Analysis:Plate Name << Split( Split By(:Chemistry), Split(:Concentration), Group(:Well Id), Output Table("Untitled 17.jmp"), Sort by Column Property ); //Save data table: Recovery_Analysis:Plate Name.jmp Recovery_Analysis:Plate Name...
lrmc_may

Discussions |
Apr 17, 2024 1:30 AM

2883 views | 4 replies
After generating a new script in a data table through JSL, why does the operation behind the original JSL stop?

For example the following JSL
Does it finish adding scripts and then stop working?Thanks!dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Eval( Parse( "dt<<new script(\!"test\!", dt<<Select Columns(ncol(dt));dt<<Move Selected Columns(after(Column(1))); " ) ); //?? New Column( "AA" );
lala

Discussions |
Apr 16, 2024 9:19 PM

1590 views | 2 replies
Write a function to join data tables

I was trying to write a function to join dt2 to dt1, however, I cannot get it to work at all... The error I got is "Name Unresolved: TrimTable at row 1 in access or evaluation of 'TrimTable' , TrimTable( dt1[1] ) /*###*/" What is wrong? Much appreciated for the help! join_data_table = Function({dt1, dt2}, {Default Local}, dt_1 = TrimTable(dt1[1]); dt_2 = TrimTable(dt2[1]); dt_1 << Join(...
DivisiveEagle45

Discussions |
Apr 16, 2024 9:36 AM

2534 views | 3 replies

Previous
Next

Latest Discussions

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

DL

Discussions |
Apr 17, 2024 4:50 AM

950 views | 0 replies
JMP Broadcasting statistical analysis

We want to investigate the way which is suitable for searching predict and forecasting of medical region.
For example, using stepwise parameter analysis, partial results of marketing will be used by data driven.
Moreover we want to develop marketing extensive predictive analysis from marketing perspective.
JMPLOVE1234

Discussions |
Apr 15, 2024 1:49 AM

929 views | 0 replies
Hover label filter generation doesn't support selection filter, skipping.

what is the reason for this warning - what does it mean?
hogi

Discussions |
Apr 14, 2024 11:26 AM

736 views | 0 replies
graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

950 views | 0 replies
Process development with multiple factors

Hi everyone, I'm currently engaged in a process development project with the goal of 1) minimizing the total process time while 2) maintaining or enhancing the yield. This objective is similar to viral vector production case, where maximizing virus yield in the shortest production time is crucial. After consulting with subject matter experts, we've pinpointed 10 factors for potential modification....
BJK_JerseyBoy

Discussions |
Apr 9, 2024 2:47 PM

1008 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

How do I create a new data table combining duplicate rows?

Quick way to populate many correlation coefficients in to a column at once?

freeze H List in the report

Col Cumulative Sum without calling the current row's value

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

Latest Discussions

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

Graph builder - reverse Y scale (only)?

Problem with Opening file (tried to make it a flexible dt name in JSL)

After generating a new script in a data table through JSL, why does the operation behind the original JSL stop?

Write a function to join data tables

Latest Discussions

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

JMP Broadcasting statistical analysis

Hover label filter generation doesn't support selection filter, skipping.

graph builder bug - x group shift

Process development with multiple factors

JMP Events

Exploring space filling designs part 2: Comparative framework and evaluation metrics