JMP User Community

Latest Discussions

Can't change the size of the spacer box?

I'm a beginner in application builder, I use spacerbox, sometimes the width can't be adjusted, sometimes the height can't be adjusted
lehaofeng

Discussions |
Nov 3, 2024 4:24 PM

1821 views | 3 replies
Formula to fix excel date format with IST and/or GMT

Look to create a column with DD/MM/YY HH:MM:SS
DELANDJ1985

Discussions |
Nov 3, 2024 12:05 AM

1075 views | 2 replies
Users Windows Screen Resolution/Scale

Hello, In regard to making scripts with jsl
Is there a way to get the user's screen resolution and scale(i.e., windows scale in system display settings)?

The problem is when some has their scale set to 150% vs 100%, the graphs and images will also change. Making it hard to read or they will completely miss a graph because they need to scroll to see it.

If I knew the answer to the first question, I'd ...
aharro

Discussions |
Nov 2, 2024 4:48 PM

1902 views | 3 replies
Is there anyway to make a column of negative numbers positive?

I'm having an issue where I want my data to be shown as absolute values. This is a query (in snowflake) with over 200 variable columns (depending on the filters) so it makes it difficult to include every column in the query. I'm ideally looking for a way to find all the columns with negative values and making them positive. (As I write this out, I guess I could transpose, place all the values in o...
OhThatArabGuy

Discussions |
Nov 1, 2024 10:20 PM

1805 views | 2 replies
Saving the file path of a user prompted Open() command

I'm prompting the user to open a file via this script command: Open() << Set Name( "results.jmp") How do I capture the file path of the file that the user chose to open?
bgolob

Discussions |
Nov 1, 2024 2:20 PM

1174 views | 3 replies

Previous
Next

Latest Discussions

Is there anyway to make a column of negative numbers positive?

I'm having an issue where I want my data to be shown as absolute values. This is a query (in snowflake) with over 200 variable columns (depending on the filters) so it makes it difficult to include every column in the query. I'm ideally looking for a way to find all the columns with negative values and making them positive. (As I write this out, I guess I could transpose, place all the values in o...
OhThatArabGuy

Discussions |
Nov 1, 2024 10:20 PM

1805 views | 2 replies
Dispatch()

I want to add reference lines to a graph, but only if the page has :name = "Closed Loop Control". The only way I have found to be successful is to grab it sequentially using the highlighted scalebox(5), however I want to grab it by the :name instead.
Jdho3

Discussions |
Oct 31, 2024 2:42 PM

663 views | 1 replies
Sequential numbering across different data tables

Hello all, I am pretty new to JSL, so I have this small doubt where I have 3 data tables, and each holds 12 rows. So, I want to add a line of code which gives me an output like for table1-the num col will be 1-12, for table2- the num col will be 13-24 and for table-3 the num col will be 25-36. Can you help me with this. Thank you in advance. <JSL> l = 117; w = 32; h = 43; ls = 19.6; ws = 16.4;...
MomentBeetle806

Discussions |
Oct 31, 2024 8:14 AM

796 views | 1 replies
How can I select rows that are the same based on one (first) column but different based on another column

Hi everyone. I am trying to formulate a script (JMP 13) that will allow me to isolate records (rows) that are the same based on one column but different based on another column. In more detail, I have made two observations/measurements on the same sample but for some samples the outcome is different. How can I isolate these cases? I have tried this (and I am likely missing something very basic -...
robin_preston_d

Discussions |
Oct 30, 2024 2:57 AM

1187 views | 2 replies
How do I identify numbers in a paragraph and extract as column in new tabel?

I have a text paragraph containing several numbers in different sentences and I would like to extract those numbers and get them stacked in a column in a new tabel.The sentence looks like this: The bags are weighed on a mobile scale at storage location. Each 5. bag is spear sampled. The primary sample of A: 10 kg, B: 20 kg, C: 30 kg, D: 40 kg and E: 50 kg was dried for 24 hours at 105 C. The samp...
CalibrationBear

Discussions |
Oct 29, 2024 12:25 PM

4536 views | 15 replies

Previous
Next

Latest Discussions

Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

677 views | 0 replies
JMP 18 Addins on Server - Change in Location

FYI from JMP tech support: If you are running JMP on a server, note that JMP 16 addins do not work for JMP 18 because the file paths have changed. JMP is no longer part of SAS so the file path changed from C:\ProgramData\SAS\JMP\addIns to C:\ProgramData\JMP\JMP\addIns

Changing your file path to C:\ProgramData\JMP\JMP\addIns will make addins visible for JMP version 18.
pmroz

Discussions |
Oct 29, 2024 5:58 AM

722 views | 0 replies
Graph Builder: Ordering my overlay by descending order according to the total value of each overlay category

Hello community, I come to you with a difficult question. Please see the image below for reference. I am using JMP 18, and I am trying to create a bar chart to show PPB values by quarter for various categories. The trouble I run into is that I want the category that has the highest total value from the chart to be on the bottom of the stack. For example, in the image below the category memory shou...
AttributedMouse

Discussions |
Oct 22, 2024 1:37 PM

709 views | 0 replies
Could JMP show in a single graph a sensitivity analysis and the probability of occurrence of a result?

Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Marco2024

Discussions |
Oct 2, 2024 5:15 PM

705 views | 0 replies
App Interface saved in a journal

Hi There
Some time ago, I created a nice interface using Application Builder and I saved it as a journal. Now I need to make a few modifications to the interface, rearrange buttons, add boxes, and so on. I am unable to import the journal into the app and have the interface appear in the Module tab. It is a very busy interface ...Is there a way to have it?
Thanks
Mioffe

Discussions |
Aug 7, 2024 5:01 PM

656 views | 0 replies