Rolling Maximum Sum Over a finite Period
Hi, I have a dataset of about 500,000 rows, each date stamped by the minute. I am trying to find the maximum sum over a 15 minute, 1 hours and 4 hour period i.e. Row 1-15 sum = e.g. 5000 (50...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I have a dataset of about 500,000 rows, each date stamped by the minute. I am trying to find the maximum sum over a 15 minute, 1 hours and 4 hour period i.e. Row 1-15 sum = e.g. 5000 (50...
Hi all, How can I insert a list from JSL to my SQL query? Currently I am using this to get the list that I need: NameList = Associative array( dtNames:"Names" ) << Get...
Hi, I have a dataset where by I have a single column with minute by minute data (time stamped) and in many cases the same minute is duplicated. For those instances, there is another column with diffe...
I have data from two studies (#1 and #2), each study had four ages of subjects (A, B, C, D) and one continuous result (score). Study #2 also has treatment groups (x, y, z, etc). I am trying to make a...
Hi all, I have a script that queries from JSL list. However, it gets an error whenever something is not existing on the database. Is there a way that I can skip what is not existing and proceed to t...
Hi all, How can I insert a list from JSL to my SQL query? Currently I am using this to get the list that I need: NameList = Associative array( dtNames:"Names" ) << Get...
I am facing difficulties in implementing the constraints for my mixture design. The design consists of water as a filler and four additives, namely A1, A2, A3, and A4, which have specified value rang...
Python integration in jmp is very useful. For debugging - when I executing a command in Python via Python Submit() and get a return value -1, indicating that something went wrong.&nbs...
Dear community, How can I use the tabulate function with the actual data of a continuous variable and not a summary statistic? Or in other words: is there a way to create a table with a col...
Hello all, I would like an Excel file encrypted with a password in JMP. However, when I import the file, JMP ask me 3 times the password. Is there a way to import an encrypted Excel file...
Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable on...
Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project. Currely i have created a jmp...
If you have are making a design with a factor you are certain will have a quadratic relationship against a response but you have a wide range, can it be helpful to define a 3rd order model effect for...
I have a script to draw charts and use "if" for the reference line. "Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it sh...
Hello community!! A query: - How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to use Text Explorer to analyz...
Topic: Building Robust and Fail-Safe Scripts Registration page: https://www.jmp.com/en_gb/...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...