Select latest timestamp (String)
Hi all,How can I select the rows with the same ID and code values but with the latest timestamp?Sample Data:
Expected Output:
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
Hi all,How can I select the rows with the same ID and code values but with the latest timestamp?Sample Data:
Expected Output:
Let's say I wrote a beautiful script, that uses some fonts - standard fonts you'd find on almost any computer, but not the JMP default fonts.I distributed this script to my users, and I started getting feedback on errors messages about missing fonts.It appears that there are computers in the organization that have a very minimal number of fonts installed.So I wrapped each Font message in Try() sta...
I'm trying to parse a nested associative array in JMP 16 (extracted from a JSON). The basic structure of the JSON is as follows:{
"groupOp": "&",
"rules": [
{"column": "col1", "op": "==", "value": 1},
{
"groupOp": "|",
"rules": [
{"column": "col2", "op": "==", "value": 2}
{"column": "col3", "op": "==", "value": 3}
]
}
}This would allow structured storage o...
Dear All, (JMP Pro 16.1.0, Win10) I have an issue related to a previous post of mine here, if you're interested in some "back story". The primary issue I'm having now is that the Throw() command is not working as expected. In my code (see at end for full code), I have in a few places a test to see whether there is currently an open graph builder report, looks like this, and it's wrapped in a...
Very new to this so please excuse if I miss anything. I would like a Main tab and sub-tabs.The below is what I am starting with. I want the main tab to be "NTLM" and sub tabs to be "Rsh" How do I properly append the chart to the tab box? Names Default To Here( 1 );
nw = New Window( "PCM Analysis",Tab Box(tp = V List Box()));
////////////////////NTLM
//////////Rsh
Variability Chart(
Y( :Rsh ),
...
Hi all,How can I select the rows with the same ID and code values but with the latest timestamp?Sample Data:
Expected Output:
I'm trying to parse a nested associative array in JMP 16 (extracted from a JSON). The basic structure of the JSON is as follows:{
"groupOp": "&",
"rules": [
{"column": "col1", "op": "==", "value": 1},
{
"groupOp": "|",
"rules": [
{"column": "col2", "op": "==", "value": 2}
{"column": "col3", "op": "==", "value": 3}
]
}
}This would allow structured storage o...
Is it possible to set a different default line width on a map shape in graph builder? Currently, every time I make a map with a referenced "map role" column in graph builder it defaults to a width of 1. To change it to the appropriate scale, I have to go to: customize graph>Shape:>line width and change it manually every time. Thanks
I'm in JMP Pro 15.2.1.I have 60 thousand observations, where the response is true/false and two categorical predictors: job, and group (assume they're not correlated). Many thousands of observations. I was about to do a logistic regression under the assumption that every observation was independent. But then I realized that each person had three consecutive response opportunities (one each quarter...
Hi,I am trying to count the number of occurrences of a character in a string. How do I achieve that using JSL?For eg:Number of occurrences of letter 'A' in the below stringsAPPLE -> 1PEARS -> 1BANANA -> 2
Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Hi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various sources. The odd thing that is happening is that when one of these scripts is run it causes all subsequent JMP windows to open under a new taskbar icon. An example for clarity: 1) User opens jmp. There is 1 icon...
Hi everyone,I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wonder if you can provide an answer:It is not clear how marginal effects are calculated in JMP.More specifically, how do we obtain marginal probabilities from marginal utilities since neither the utility fun...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...