SQL Query custom expression - date range
I am trying to pre-filter a Query based on date range, but can't figure out how to get it to work. I keep getting this error. I have to be missing something simple, right?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am trying to pre-filter a Query based on date range, but can't figure out how to get it to work. I keep getting this error. I have to be missing something simple, right?
I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is ...
Hello everyone, I would like to know how to count the number of "OTPs" that are equal to 0 and make the division on the total number of LINES of OTP ? Thank you for your help
Hi, I'm trying to manipulate a data table with a formula, but I only want it to read for a few rows. Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Cars.jmp" ); r = Current Data Table() ...
Basically I'm building a custom interactive window which includes different display boxes and I'm trying to simplify the selection input with a for loop. For instance, I have both a combobox & a ...
I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is ...
Dear JMP Community, I am new to JMP and wanted to build a widget which would allow sliding spec limits and resulting yield assessments for a product. Such a capability can be super helpful f...
Hello! Does JSL have modules for text encryption and decryption? Thanks! AHK String(AlgId, Mode := "", String := "", Key := "", IV := "", Encoding := "utf-8", Output := "BASE64")
Hi Folks, I'm troubleshooting an issue with some JMP queries and I've discovered I can see and access the required Oracle tables within a schema when I open the tables using the Database/Open Table o...
If I run the Fit Modelplatform, the "Combined Prediction Profiler" in the resulting Fit Group has pink shadings that indicate the factor's importance. Now I save the Fit Group, either using Save As, ...
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 s...
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 wond...
JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for...
Dear All, I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Othe...
Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column matc...
4 Day Course Monday, July 22| 9:00 a.m. - 12:30 p.m. ET Tuesday, July 23 | 9:00 a.m. - 12:30 p.m....
Learn the basics of using JMP without leaving your desk. Sign up for complimentary Web training, liv...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to interactively automate anal...
Register here: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-python-30jul2024.html &nb...