JMP User Community

Latest Discussions

for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...
j0rg

Discussions |
Oct 6, 2023 1:54 PM

1357 views | 1 replies
Change Single Bar Color

Hi All, I have a seemingly simple question that I cannot find the answer to. I have made a bar graph and would like to custimze the each bar graph fill color individually. The graph is cost on y axis and car make on x axis, with each car make having two years. The reason is I have a general fill color depending on the year (2017&2018), but would like to highlight certain car make a different color...
GERblob

Discussions |
Oct 6, 2023 1:20 PM

11164 views | 3 replies
Name Unresolved: Column name will not resolved when I specify it as a value in a list

I am trying to calculate the AUC for each column in a data table. I am collecting all of the column names into a list "colNamesList", and retrieving each column name in Fit Model inside a For loop by incrementing the list subscript. However, the call to the array is not resolving inside the Fit Model call. If I include show(colNamesList[i]) on a separate line, it resolves fine, just not inside th...
ond_stats

Discussions |
Oct 6, 2023 11:54 AM

2838 views | 3 replies
REML analysis / Iterations Converged in the Gradient

What is the significance of the statement "Iterations Converged in the Gradient" in the Iterations output within the REML Variance Component Estimates Report? Also, what is the impact on using this REML analysis to evaluate residual error if the iterations do not converge in the gradient? Is this an indication that the dataset was not amenable to the analysis? Thanks!
dwillingmyre

Discussions |
Oct 6, 2023 8:50 AM

1200 views | 1 replies
Fit Group and Fit Y by X

Hello! I'm attempting to script an analysis where the user inputs a data table, and the script runs a fit Y by X with a user selected column through a column dialog box as Y and all other columns (which can be any mix of continuous and nominal variables) as the X selections. Is there a way to use fit Y by X and Fit Group together to get this all-in-one window and easily allow for the results to be...
kbatch

Discussions |
Oct 6, 2023 7:00 AM

1811 views | 2 replies

Previous
Next

Latest Discussions

for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...
j0rg

Discussions |
Oct 6, 2023 1:54 PM

1357 views | 1 replies
REML analysis / Iterations Converged in the Gradient

What is the significance of the statement "Iterations Converged in the Gradient" in the Iterations output within the REML Variance Component Estimates Report? Also, what is the impact on using this REML analysis to evaluate residual error if the iterations do not converge in the gradient? Is this an indication that the dataset was not amenable to the analysis? Thanks!
dwillingmyre

Discussions |
Oct 6, 2023 8:50 AM

1200 views | 1 replies
Are text files locked when importing?

Hello, I’m writing a script to scrape machine log text files and collect the data in JMP. Some of these files are ‘active’ and may be appended to or even moved.

I’m wondering whether JMP acts like Notepad where the file is not locked at all, or if there is a small chance the import will block another program manipulating the file.

My question is for all versions of JMP 17 for Windows
bculver

Discussions |
Oct 6, 2023 4:34 AM

762 views | 1 replies
Error message in JMP

HelloI have a strange reaction of JMP.I tried to create a variability graph for 13 units, but I received about 25% of the data on the graph, and I had a pop-up error to write to the log?What should I do to create a graph for all the data that I have in the table?
Dennisbur

Discussions |
Oct 5, 2023 11:31 AM

1311 views | 3 replies
Jmp connect to AAS (Azure Analysis Service)?

Hi, I would like to know if it is possible to connect JMP with an AAS (Azure Analysis Service) ? thanks
Shoal

Discussions |
Oct 5, 2023 6:31 AM

1113 views | 1 replies

Previous
Next

Latest Discussions

Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

618 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

1124 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

848 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies