JMP User Community

Latest Discussions

Script to make a toolbar button to turn on and off graph builder fit to window

Hey everyone,I was wondering if someone could help me out with a script that I could assign to my toolbar so that I could "one click" turn graph builders "Fit to Window" options on and off So if it I clicked it and the current selection was "Auto/On/MAR" then it would set Fit to Window to "Off" and if the current section was "Off" then it would set Fit to Window to "On". Thanks for any input on ho...
shampton82

Discussions |
Apr 18, 2024 12:21 PM

1386 views | 4 replies
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 & 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

1455 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

1646 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

1149 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

7591 views | 15 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

598 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

1444 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

1907 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

980 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

1633 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

598 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

593 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

491 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

581 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

663 views | 0 replies