How can set different cells to different colors
dt=Open("$SAMPLE_DATA/Big Class.jmp");
dt[1,1] is set to red
dt[1,2] is set to white
dt[1,1] is set to clear coloringThanks!
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
dt=Open("$SAMPLE_DATA/Big Class.jmp");
dt[1,1] is set to red
dt[1,2] is set to white
dt[1,1] is set to clear coloringThanks!
HelloI have a table with 2 columns, "% of Total" and "Correlation"I would like to sort simultaneously both columns in Descending only but when I run the script, the column Correlation is sorted like Descending but % of Total is sorted like Ascending What is wrong with my script? dt << sort ( by ( "Correlation" , "% of Total" ), Order ( Descending ), Replace table );
Hi,JMP has constitute the linear regression formula. In this case Q is the slope. I wanted to see the Q=7 and Q=8 demonstrated in the line plot about. How do I do that in jmp. Otherwise I need to calculate and put in excel or data table,
It seems like I have a .bat file that runs a JSL script, which processes multiple CSV files as input.
However, when the number of input CSV files increases, the .bat file often crashes and takes a long time without completing the task.On the other hand, executing the same number of input CSV files through JMP and the JSL script only takes 1-2 hours.The speed difference is significant. Do you know t...
Redo Analysis from the the red triangle/Redo menu is great.It generates an exact copy of the current report. Is there also a possibility to get an exact copy of a report (e.g. Graph uilder Plot ) that is inside a Dashnoard?
- including the filters that were applied by the surrounding dashbord?
dt=Open("$SAMPLE_DATA/Big Class.jmp");
dt[1,1] is set to red
dt[1,2] is set to white
dt[1,1] is set to clear coloringThanks!
Redo Analysis from the the red triangle/Redo menu is great.It generates an exact copy of the current report. Is there also a possibility to get an exact copy of a report (e.g. Graph uilder Plot ) that is inside a Dashnoard?
- including the filters that were applied by the surrounding dashbord?
I would want to get the date yesterday, I am using the today () functiondateNow = Format (Today(), "m/d/y");
However, I don't know how to derive from dateNow the date yesterday. Tried using d = (dateNow - 1);but is not working.
Hi, I use include() to run multiple JSLs in each JSL I have variable "todaydate". However, now I want to run all the JSLs using include, but change the todaydate across all JSLs to 03Jun2023. How I can do that ? todaydate = Format date( Today(), "ddmonyyyy" );
I was thinking:
todaydate = "03Jun2023"; // this will replace in all 10 jslinclude(jsl1);include(jsl2);...include(jsl10);
Suppose I have a table of RunNumber (1,2,3...) and Result (numeric/continuous). How can I create a formula column that identifies (e.g. with a "1") the sequence of 5 Result numbers with the lowest average value for each RunNumber, and a "0" everywhere else?
Redo Analysis from the the red triangle/Redo menu is great.It generates an exact copy of the current report. Is there also a possibility to get an exact copy of a report (e.g. Graph uilder Plot ) that is inside a Dashnoard?
- including the filters that were applied by the surrounding dashbord?
Hi,Is there a way for me and a collegue to work on the same JMP file in real time?We have JMP 17. Thanks!
Hello!For example, using large class data:
Compare the height column and the weight column to see which column fits the sinusoidal distribution better.
The parameters of the sine curve are random. Thanks!
When designing dsd with 49 factors and 4 additional runs. Why do I get 109 runs and not 105 runs?
In JMP 16 (Windows) , I removed the F1 hotkey from Help and set up as a new function using Custom Menus and Toolbars.I did the same in JMP 17 standard, and yet when I hit F1, I still get the Help browser link. Is there another place that F1 is set up that I am missing? Or is it hardcoded?
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...