JMP User Community

Latest Discussions

How to convert Column Data type from Character into Numeric wihtout losing Numeric values in the column

Dears, Started with JMP few weeks ago !! It's a naive question. I am trying to convert a column Data type from Character to Numeric, however i am losing the all the Numeric values from the column while converting the data type to Numeric. Please find the attached screenshots for the same. How to retain the numeric values from a column when i change it's data type from Character into Numeric?? Tr...
AlexR846

Discussions |
Mar 28, 2022 11:22 AM

16984 views | 10 replies
How to check if Lag(:column, N) points to existing row

Whern I use Lag(function) I usually do not lag more than one row, so I just include a condition for the first row. But what if I have multiple Lags with different amounts of rows to lag? What would be the best way to check if it refers to an existing row, leave as is, if it lags to before the first row - just return 0? I would try something like Is Scriptable(), but it doesn't' work in this case.
miguello

Discussions |
Mar 28, 2022 11:01 AM

968 views | 1 replies
need to plot a regression line that includes my custom computed upper and lower error bars

Hi - I am trying to write a script that will plot my computed regression value along with my custom computed upper and lower error bars. That is, for each independent value, my chart would plot the dependent (regressed) value, the upper bound, and the lower bound. My chart would look something like the example below, ideally with the error range shaded. Thanks in advance!
learning_JSL

Discussions |
Mar 28, 2022 9:25 AM

1916 views | 4 replies
Column Search using list of Partial String

I'm trying to get rows where the value has a match from a defined list of partial strings. Example below. The partial string which I'm interested is either "aaa" or "aa bb". I've started with the JSL below. Ideally, the result is [1,2,4,5,7,8,11]. The script below was able to get everything except for the last one (11). Nevertheless, perhaps there are more elegant solutions than what I have as wel...
Djtjhin

Discussions |
Mar 28, 2022 9:03 AM

3557 views | 9 replies
Box-plot with points aligned in box plus violin plot

Good afternoon all,I wanted to create a graph in which the points fell exactly within each box-plot and the related violin plot.
Using the graph builder, I realized that the points don't line up inside the box.
Anyone have any idea how to fix this?
I attach photos.
GiuseppeC

Discussions |
Mar 28, 2022 8:39 AM

6906 views | 13 replies

Previous
Next

Latest Discussions

"Weight" in "Fit Y by X" (and perhaps generally in JMP platforms)

I have data from several (22?) samples, which vary considerably in sample size. I understand that parameters are estimated better with larger samples, but that is not the issue I want to address here. It is that I would like to both graph distributions, and estimate parameters, as if the sample sizes didn't differ across the groups/samples. This means that large samples will need to be de-weighted...
profjmb

Discussions |
Mar 28, 2022 5:37 AM

2799 views | 3 replies
CUSUM chart with subgroup variable

I'm trying to understand how the cusum chart is calculated usind a subgroup variable X where some X values are present multiple times. For example, I have 3-5 measurements per day and the cusum chart should be grouped by day. Since it says in the JMP help regarding X "If a value of this column is present more than once, the average response at each X value is plotted on the CUSUM chart.", I though...
Kristin

Discussions |
Mar 28, 2022 12:27 AM

2641 views | 4 replies
Association Analysis no showing up in menu.

Hello, I ran into an issue while trying to work on a homework assignment. My JMP Pro doesn't have association analysis, I tried to adjust the preferences, I restarted my setting, restarted my computer, I even uninstalled and reinstalled JMP Pro but this problem persiets. I download JMP pro on my roommate's computer and again, I ran into this issue. I emailed JMP support about this but I haven't fo...
DualJackal898

Discussions |
Mar 27, 2022 10:07 PM

4390 views | 1 replies
Mixed Logit Model

How do I perform a Mixed Logit Model on JMP?
ARR

Discussions |
Mar 26, 2022 6:01 AM

857 views | 1 replies
May I change Color of Col' head????

Hello,
I have a quick question.
Can I change the color of the JMP data table col' head?
As you can see now, we are dividing by changing the color of the cell, but it would be great if we could only change the head, not the whole.
(Actually, I think it would be better if we could form a group by column on data table toooo)
Thank you..
Dongjin

Discussions |
Mar 25, 2022 5:46 AM

906 views | 1 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

590 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