JMP User Community

Latest Discussions

Insert Hyperlink in Text in the cells

Hi, I am creating data table report, save it as html file and then distribute it to my team for review.In the data table cells, I would like to insert hyperlink to the text (e.g. Report) in the cells, as shown in below example.This can done easily in MS Excel.Is there a way to do this in JMP through JSL? I am using JMP 12.
bzanos

Discussions |
Jul 20, 2021 5:33 AM

3062 views | 4 replies
Multi-group analysis in JMP

Hello community! I want to do multi-group analysis in JMP. For example, I have 150 Instagram respondents and 130 YouTube respondents. I don't know how to create two groups (pooled variables) and then do the analyzes. I don't want to compare or join: just do regressions / Anova to compare the responses of the Instagram group to that of YouTube. Am I clear? Can you help me? Thank you Nataly
NatalyLevesque

Discussions |
Jul 20, 2021 2:42 AM

1649 views | 2 replies
Taking column average based on some condition on other column

I am looking for a method to take average of column data based on some condition on another column.The table below shows what I want to achieve. I want to take time averaged intensity value and tabulate a new column with the averaged value.The average will be taken based on 'Step' & Group as a trigger i.e all intensity values from same Group & same Step willbe averaged and tabulate once. I tried C...
Neal85

Discussions |
Jul 19, 2021 9:25 PM

4864 views | 4 replies
Compare two tables and retreive relevant rows from one table based on the other.

I have 2 tables.Table 1: Timestamp (in 15 minute intervals),i1,i2,i3,p1,p2,p3,p4,.... (182 columns)Table 2: Year, Month, Date, StartTime, EndTime ( StartTime and EndTime is in the format- h:m am/pm)I would like to select all 182 columns and only the rows in Table1 which lies between StartTime and EndTime of Table2 and make a subset.Note:StartTime and EndTime for every date in Table2 could lie any...
SymS

Discussions |
Jul 19, 2021 6:44 PM

1517 views | 3 replies
Exporting Heatmap Values to datatable

Hi all, I'm trying to directly exporting the mean values showed in heatmap cells to data table. Is there any way to do that? Thanks in advance
JaredJ

Discussions |
Jul 19, 2021 5:17 PM

1839 views | 2 replies

Previous
Next

Latest Discussions

Multi-group analysis in JMP

Hello community! I want to do multi-group analysis in JMP. For example, I have 150 Instagram respondents and 130 YouTube respondents. I don't know how to create two groups (pooled variables) and then do the analyzes. I don't want to compare or join: just do regressions / Anova to compare the responses of the Instagram group to that of YouTube. Am I clear? Can you help me? Thank you Nataly
NatalyLevesque

Discussions |
Jul 20, 2021 2:42 AM

1649 views | 2 replies
Compare two tables and retreive relevant rows from one table based on the other.

I have 2 tables.Table 1: Timestamp (in 15 minute intervals),i1,i2,i3,p1,p2,p3,p4,.... (182 columns)Table 2: Year, Month, Date, StartTime, EndTime ( StartTime and EndTime is in the format- h:m am/pm)I would like to select all 182 columns and only the rows in Table1 which lies between StartTime and EndTime of Table2 and make a subset.Note:StartTime and EndTime for every date in Table2 could lie any...
SymS

Discussions |
Jul 19, 2021 6:44 PM

1517 views | 3 replies
JMP15 Graph Builder does not update Map after changing -XY coordinates file

old working JMP13 script does not work anymore with JMP15. The script changes the coordinates of -XY map file and neither Graph Builder updates nor the changed map appear creating a new graph builder instance. Just opening a new session new map is shown. It looks like that a sort of caching prevent updates.Is it possible to fix or workaround this behavior?dt2 = open("C:/TEMP/map-Name.jmp"); dt3 =...
antonio-domenic

Discussions |
Jul 19, 2021 9:04 AM

1631 views | 3 replies
Dashboards taking too long to create and edit

I am using JMP-Pro 15.1 and building dashboards using the existing templates seems to be taking a really long time on my computer compared to the JMP demonstration videos I have watched where the presenters seem to be breezing through the dashboard building process. As an example, when I open a template and try to drop in plots, there is a significant lag and it takes several seconds for JMP to t...
vm

Discussions |
Jul 19, 2021 6:58 AM

847 views | 1 replies
Automation of Reports for PowerPoint Templates with JMP 15

Hi all,

I run weekly reports on physiochemical attributes. The old process was to manually input data from excel into JMP. After entering the new data into JMP two scripts are run: Run Chart and Control Chart scripts, that are saved to the Data Table. These scripts have limits of precision and formatting applied (or saved into the scripts). Then the charts are copy & pasted one by one into a PowerP...
lich365net

Discussions |
Jul 19, 2021 6:52 AM

1608 views | 2 replies

Previous
Next

Latest Discussions

Graphlet disappearing after filtering through a null set

Have a tool I built that has a series of graphlets in them. Noticed some odd behavior. The top-level graph has a local data filter. Some combinations of that data filter will result in no data. When I filter to a no-data set, then expand back to a set with data, the graphlet no longer exists. Any ideas on how to retain the graphlets after filtering?
Evan_Morris

Discussions |
Jul 12, 2021 10:28 AM

874 views | 0 replies
Obtaining a p-value for an odds ratio of a continuous variable

Hi all,When performing an odds ration analysis on a nominal variable I get a p-value which is identical to the p-value of the parameter estimate (see pic below). When performing the same on a continues variable there is no p-value (see pic below). Could I use the p-value of the parameter estimate as the p-value of the odds ratio?If not how could I obtain the p-value in JMP?TIA
eliyahu100

Discussions |
Jul 7, 2021 10:27 AM

1486 views | 0 replies
How do I get Odds Ratios after fitting a GLM with binomial distribution and logit function?

Hi everyone,I need to get OR after fitting a GLM with binomial distribution and logit function - that is a logistic model. I cannot fit a "nominal logistic" where there's the option for OR because I need to use the Firth adjustment for small-sample bias (I can only do that for that GLM). Is there an option to get the Odds Ratios? Thank you in advance. Antony
Antony

Discussions |
Jul 7, 2021 10:04 AM

877 views | 0 replies
Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

704 views | 0 replies
Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

872 views | 0 replies