JMP User Community

Latest Discussions

How to aggregate Character columns?

Do you know the difference between Tables/Join and Tables/Update ? If there are multiple matching rows in the source table, Tables/Join fills the cells of the merged column with the value of the FIRST matching row - Tables/Update fills the cells with the value of the LAST matching row. (actually it fills it step by step with the values of all matching rows and the last one sticks: https://communi...
hogi

Discussions |
Sep 14, 2023 11:45 AM

1223 views | 1 replies
conditional data filter + invert selection: bug?

When a data filter is configured to be conditional, selections in one filter affect the values which are displayed in other filters: When the user opens the red triangle menu and clicks on clear selection, the filter is reset and the other filters are adjusted accordingly. Surprising: When the user opens the red triangle menu and clicks on invert selection, the selection is just inverted, but no...
hogi

Discussions |
Sep 14, 2023 11:39 AM

2987 views | 8 replies
How to show the actual range in the level values in Graph Builder?

Hi, In the attached plot, the property of column "ChannelNumber" is Numeric/Continuous. I found it confusing in the grouped values at the top. "0-4" actually includes 0-3, as shown at the bottom; "4-8" actualy includes 4-7. It seems the range at the top always has overlapping values between adjacent levels. What can I do to make this overlap go away (i.e. I want it to show "0-3", "4-7","8-11" at...
JaneYang

Discussions |
Sep 14, 2023 11:28 AM

5459 views | 13 replies
IDENTIFY LARGEST 3 VALUES TO CREATE INDICATOR COLUMNS

Hi,I'm a trying to compare across column values (Utility A to Utility E) to identify the largest 3 values and put the results into indicator columns ("Top 3 - A" to "Top 3 - E"). So, if "Utility A" is one of the largest 3 values in the row, "Top 3 - A" would receive a "1". If the value is NOT one of the 3 largest in the row, "Top 3 - A" would receive a "0". I tried using "Match", but wasn't abl...
EH1

Discussions |
Sep 14, 2023 10:14 AM

1433 views | 2 replies
Graph Builder: reverse scale - bug?

Hi,when I reverse the scale of the Legend in Graph Builder, the colors in the graph are inverted as well.For the colors in the graph, reverse scale and reverse colors has the same effect: As a result, in this plot, the colors run from red to blue for height 50 -> 70.And in the legend the colors run from blue to red for height 50-> 70. I tested it with Jmp 16 & 17. So if it's a bug, it's there for ...
hogi

Discussions |
Sep 14, 2023 7:53 AM

1670 views | 2 replies

Previous
Next

Latest Discussions

conditional data filter + invert selection: bug?

When a data filter is configured to be conditional, selections in one filter affect the values which are displayed in other filters: When the user opens the red triangle menu and clicks on clear selection, the filter is reset and the other filters are adjusted accordingly. Surprising: When the user opens the red triangle menu and clicks on invert selection, the selection is just inverted, but no...
hogi

Discussions |
Sep 14, 2023 11:39 AM

2987 views | 8 replies
How to show the actual range in the level values in Graph Builder?

Hi, In the attached plot, the property of column "ChannelNumber" is Numeric/Continuous. I found it confusing in the grouped values at the top. "0-4" actually includes 0-3, as shown at the bottom; "4-8" actualy includes 4-7. It seems the range at the top always has overlapping values between adjacent levels. What can I do to make this overlap go away (i.e. I want it to show "0-3", "4-7","8-11" at...
JaneYang

Discussions |
Sep 14, 2023 11:28 AM

5459 views | 13 replies
Simpler way to save a new script to data table

(1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...
Ake

Discussions |
Sep 14, 2023 6:15 AM

1068 views | 1 replies
Rename columns contains certain symbol

Hello dear users/experts, I have a table has many columns, where some of the columns are started with "std" (some are not),for example column names could be:std_A, std_AX, med_XA,data_Ex,std_BN.... And i would like to change to A_std, AX_std, med_XA, data_EX, BN_std... only remove std at the begining of column names and put them in the end with _
MarkovRootFox46

Discussions |
Sep 14, 2023 1:40 AM

778 views | 1 replies
Actual by Predicted plot.- expand x/y axis for confidence region

Hi, I'm trying to build a model using the "Fit Model" platform and expand the x and y range of the Actual by Predicted plot. However, once I do that, I get to a point where the confidence interval and the mean prediction line are no longer shown (see below). Any thoughts on how to fix this? Thanks!
mkiesz

Discussions |
Sep 13, 2023 1:12 PM

1534 views | 3 replies

Previous
Next

Latest Discussions

Mixed model: which specifications for cross-over designs?

I ran a cross-over trial where healthy volunteers came to the lab twice (separated by a wash-out period) and underwent sensory testing at both arm and foot, before and after one of two neuromodulation interventions. Each participant underwent both conditions in a randomly assigned order. We want to see if the neuromodulation interventions affected the outcomes differently for the arm and the foot....
arnaudsteyaert

Discussions |
Sep 13, 2023 7:30 AM

853 views | 0 replies
Exporting Graphs from Tab box to Excel cell

Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...
Jackie_

Discussions |
Sep 12, 2023 2:09 PM

726 views | 0 replies
Discrete Choice Experiment: Prohibited Combination

Hi everyone,I would like to design my first DCE. I am going to use 6 attributes that differ in the levels from 2 to 4 levels. However, I have a limitation where there is an impossible combination that may appear; for example, the cheapest product would not be possible to have the best feature. Is there any way for me to select the prohibited combination? Or, is the D-optimal design will always cal...
andikawp

Discussions |
Sep 6, 2023 7:11 AM

707 views | 0 replies
Multivariate Analysis

Using Multivariate Analysis to study the pattern of any specific issue (e.g. water consumption of different states in a country). From T2 plot for abnormal observations we get contribution plot that shows which states are highest contributor. The Contribution plot here shows only the name of contributors. If it possible to indicate in numeric value [How much water each state is consuming]?
Chitranshu

Discussions |
Sep 4, 2023 3:01 AM

647 views | 0 replies
PickFile() from within a Project does not use file filters

When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...
R2OKeefe

Discussions |
Sep 3, 2023 8:45 PM

1031 views | 0 replies