Adding hours to existing date/time column
Hello,I am attaching a table here with the first column showing UTC date\time. How do I use JSL to generate a column called Taiwan Time by adding 8 hours to the 1st column? Thanks, Cryz
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello,I am attaching a table here with the first column showing UTC date\time. How do I use JSL to generate a column called Taiwan Time by adding 8 hours to the 1st column? Thanks, Cryz
I am planning to analyze circadian rhythm data and can fit it to the Savitzky-Golan smoother with a cubic degree and local cosine weighting. This provides a visual with a confidence of fit. However, is there a way to statistically determine the quality of the fit to the cosine waveform? I have tried saving the smoother formula to the data table then launching the analysis using the upper and low...
Using JMP 17.1. How can I send a message to, say, the Points element of my Graph Builder to change the summary statistics from one to another (like Range to Standard Deviation)? It should come down to properly referencing the Points, right? Thanks!
I would like to reset the Text Edit Box to empty using the reset button in the script below. How to do this? Names Default To Here( 1 );
clear log ();
nw = New Window( "Get Data",
<<Modal,
<<Return Result,
pid = Text Edit Box( "", <<Set Width( 160 ) ),
Button Box ("Get ID & Data",
ID = pid << get text;
show (ID)),
//getData (ID); run getData script. Get data script will go here.
Button Box
...
I'm trying to find a way to combine the two wafer maps below. In other words, I need the X/Y coordinates to actually appear as rectangular die areas on a wafer, like in the heatmap below (not as points), AND have the legend to be discreet and maybe customized colors like in the point map below (not as a continuous gradient from 0-4). Is there any way to combine these features? TIA! Heatmap: Point...
I am planning to analyze circadian rhythm data and can fit it to the Savitzky-Golan smoother with a cubic degree and local cosine weighting. This provides a visual with a confidence of fit. However, is there a way to statistically determine the quality of the fit to the cosine waveform? I have tried saving the smoother formula to the data table then launching the analysis using the upper and low...
I'm trying to find a way to combine the two wafer maps below. In other words, I need the X/Y coordinates to actually appear as rectangular die areas on a wafer, like in the heatmap below (not as points), AND have the legend to be discreet and maybe customized colors like in the point map below (not as a continuous gradient from 0-4). Is there any way to combine these features? TIA! Heatmap: Point...
HI JMP users, I have a column that contains data in the format DD-MM-YY H:M:S (screenshot attached below), and I would like to adjust only the hour values to make them even. For example, I want to change a time like 13-07-2023 15:00 to 13-07-2023 16:00. Is there a method to modify only the hour values across the entire column? Regards,
Hi All,I am trying pull some data from the database by looping through dates, in this example, I am trying to loop from June until the date yesterday. This is my sample code. However, it is not working. Can someone explain how to properly do it? TIA d = Today() - In Days(1);
dateNow = Format (d, "m/d/y");
startdate = "2023-06-01";
For( i = startdate, i <= dateNow, i++,
try(
dt = Open Database( "
...
My recent files list gets longer and longer - and it gets hard to find the important files.It helps to use the pinning option - but now also the list with the pinned files continues to grow. I there a grouping option such that I can add some structure?
Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
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...
Jump into Graphing Date: Wednesday, September 24Time: 1:00 – 2:30 p.m. ETDura...
German Mastering JMP Webinar Finden Sie heraus, wie Sie Analyseschritte interaktiv automatisi...