JMP User Community

Latest Discussions

Using Excel Wizard to import time with milliseconds

I am trying to import time data with milliseconds. It is in hh:mm:ss.000 format in Excel. If I simply copy and then "paste with column names" into JMP, it imports correctly. JMP does not show the milliseconds but it does interpret it correctly, and when graphing a response variable against the Timestamp column, the graphing works correctly, generating points appropriately spaced to coincide with...
Dana_Ray

Discussions |
Apr 1, 2022 8:50 AM

3175 views | 2 replies
How to change the VBA of excel to JSL in order to download data?

Hello, everyone!The VBA can download data from this website.But I don't know how to change it to JSL to make it work.Thank you very much!Sub Post() Dim User_agent, Url_Post User_agent = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36" Url_Post = "http://excalc.icfqs.com:7616/TQLEX?Entry=HQServ.hq_nlp" Post_data = "[{""funcId"":4,"...
lala

Discussions |
Apr 1, 2022 8:01 AM

2599 views | 4 replies
How to embed pre-made scripted graph into Application Builder module?

Hi Everyone, I am scripting in Application Builder. In one of my modules, I have a Graph Box, with the intention of setting it to display a pre-made graph, but I am not having much luck. I was originally thinking that the easiest thing to do would just be to somehow embed my pre-made graph into the module window, so I have been trying to use the Graph Box as a placeholder, trying something like:gr...
EstelleS

Discussions |
Mar 31, 2022 6:43 PM

1350 views | 1 replies
Gantt Chart

Hello everybody, i would like to generate a plot which is showing the machine capacity (with a defined production time) of 5 different machines over a certain period of time (see the attatched image). It is quite similar to a gantt Chart. Do you have any suggestions how to build this graph? Thanks in advance. Kind regards, Johannes
JohannesENS

Discussions |
Mar 31, 2022 5:40 PM

2775 views | 2 replies
Distribution plots not showing in Journal saved as html

Hi,I have created a Journal with multiple Distribution Histogram and Tables using scripts and saved as .html. When I email and share the html file with other people, the embedded graphs are not showing. I think it's because the img src link is pointing to a local directory in my computer. How do I fix this so that I can share the .html journal with the graphs? I'm using JMP 16.Thank you!Irene
ihnleung

Discussions |
Mar 31, 2022 2:34 PM

1810 views | 3 replies

Previous
Next

Latest Discussions

ANOVA with Binary Data - What do these extreme outliers mean?

Hello, I have a large set of binary data (0, 1). I am using JMP Genomics ANOVA to compare the means between two groups. I was expecting a significant difference between Group 1 and HC for certain genes that are not represented as significant on the volcano plot nor the associated data. For example, For Gene S Group 1 has 100% homogeneity (mean of 1) and HC has a mean of 0.2. However, the volcano p...
JMPUser5400

Discussions |
Mar 31, 2022 6:45 AM

5435 views | 5 replies
Identifying Columns Best Correlated to A Single Column

Hi, I have a table with a "result" column and about 100 process variable columns. I want to know which process variable affect my result most. One simple way is to plot Each Process Variable Vs. Result and take a look at the box plots for correlations. But, visual inspection of 100 columns is pretty tough. Is there a way to automate that process. I appreciate your response.Seshadri
seshadri

Discussions |
Mar 31, 2022 3:14 AM

10712 views | 7 replies
How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Hi All,I'm trying to run batch file automatically every day when radio button -"run whether user is logged on or not" is selected and it doesn't work.
It works only when radio button "run with the user logged on" is selected.
Can you advise please?Thank you
Botzal

Discussions |
Mar 30, 2022 10:58 PM

11173 views | 13 replies
Showing p-value for parameter estimates in choice model report

Hi,I'm using the choice model platform. I notice there are "estimate" and "standard error" in the "parameter estimate" report, but I'd also like to know the p-values for my parameter estimates. How can I do that?I see one can double click on the cell to set column numeric format and do conditional highlighting by p-value, but JMP highlights the estimates and the std err in different ways (as shown...
bellaw

Discussions |
Mar 30, 2022 10:16 AM

3033 views | 7 replies
How to have graph bars on the exact x value

Hi,I created a graph to show the number of claims received by date.For this case there is one claim received on the 24th June 2019. Why is the bar not indicating the right date but showing an interval (even though bar style is side by side and width proportion is 0 )? How to change it to show the exact date? Needle bar style is not an option as the bar is too thin and not easily readable.Thanks. ...
MahaRabeh

Discussions |
Mar 30, 2022 8:24 AM

2618 views | 7 replies

Previous
Next

Latest Discussions

Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

842 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

599 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

771 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies