JMP User Community

Latest Discussions

format date

Bonjour,Je dispose d’une BD avec deux colonnes : entrée et sortie.
Ces colonnes sont des dates mais sont au mauvais format.
Par exemple la cellule 14,45 correspond à 14h45. J’ai essayé en modifiant le format de la colonne en disant qu’en entrée il s’agissait de format numérique et en sortie je voudrais « h:m » comme ci dessous : cela ne fonctionne pas, avez-vous une idée pour résoudre ce problème ...
hcarr01

Discussions |
Sep 14, 2023 11:38 PM

1696 views | 3 replies
Inherited Plot settings

Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi

Discussions |
Sep 14, 2023 11:11 PM

654 views | 0 replies
Graph Builder Fit line or spline through points with summary statistic

Hello, In graph builder, I make a Y-X scatter plot, and want to show the points as "Max" values, so I choose the "Max" Summary statistic. When I try to fit a regression line or spline through the data, it doesn't appear to attempt to fit it to the "Max" points. I'd like to fit them through the "Max" summarized points. How can I achieve this?
ashwint27

Discussions |
Sep 14, 2023 8:12 PM

1404 views | 2 replies
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

Previous
Next

Latest Discussions

Inherited Plot settings

Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi

Discussions |
Sep 14, 2023 11:11 PM

654 views | 0 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
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

Previous
Next

Latest Discussions

Inherited Plot settings

Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi

Discussions |
Sep 14, 2023 11:11 PM

654 views | 0 replies
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