Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Need help to populate the correct column value in the distribution graph

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Need help to populate the correct column value in the distribution graph

Dec 12, 2017 7:23 PM
(2069 views)

Hi All,

I am new to the JMP scripting. I need help to populate the data that i calculate to the distribution graphs plotted. For example, i have 3 distribution graph plotted and there are 3 value was calculated out from the graph plotted.

So, i want to use each respective value from each graph and plotted it again on each respective graph it was calculated. There are few problems i am facing right now as below.

1. How to insert the value calculated from each graph to its respective graph. i try to wildcard (*) but seems not working. The graph has its own name so im thinking wildcard can help me here but it is not working.

2. The value calculated from each graph is in the summary table, so if i try to put the value manually to the graph by using the reference name in the summary table, it will always take the last value in the table and didnt not refer to its respective value it was calculated.

sample code and example for summary table are as below:

you can see in the second distribution graph in the code i try to called the value calculated using formula 'LSL' and 'USL' which is 'LSL_Calc=0.047' and 'USL_Calc=0.0869' for Speed_Test, but it will always take the last value from Stress_Test value to draw on the disctribution graph . How to make it know that it need to the value from its respective TEST_NAME which is Speed_Test. Is there any array or somekind command that i need to use?

TEST_NAME | N Rows | Mean(NUMERIC_RESULT) | Std Dev(NUMERIC_RESULT) | LSL_Calc | USL_Calc |

Drop_Test | 5 | 0.2942 | 0.031518 | 0.105092 | 0.483308 |

Speed_Test | 5 | 0.06705 | 0.003314 | 0.047167 | 0.086933 |

Hot_Test | 5 | 0.52175 | 0.009736 | 0.463337 | 0.580163 |

Stress_Test | 5 | 0.39655 | 0.044266 | 0.130956 | 0.662144 |

```
dt = Open ("C:\Users\malwi\Desktop\MyAutomation\Newtable\table1.csv");
Distribution(
SendToByGroup( Bygroup Default ),
Stack( 1 ),
Continuous Distribution(
Column( :NUMERIC_RESULT ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Count Axis( 1 ),
Normal Quantile Plot( 1 )
),
By( :TEST_NAME );
);
Summary(
Group(:TEST_NAME ),
Mean( :NUMERIC_RESULT ),
Std Dev( :NUMERIC_RESULT )
);
New Column( "LSL_Calc",
Numeric,
Continuous,
Format( "Best", 8 ),
Formula(
LSL = :Name( "Mean(NUMERIC_RESULT)" ) - 6 *:Name( "Std Dev(NUMERIC_RESULT)" )
),
);
New Column( "USL_Calc",
Numeric,
Continuous,
Format( "Best", 8 ),
Formula(
USL = :Name( "Mean(NUMERIC_RESULT)" ) + 6 *:Name( "Std Dev(NUMERIC_RESULT)" )
),
);
wait(1);
dr = Fit Group (
Distribution(
SendToByGroup( Bygroup Default ),
Stack( 1 ),
Continuous Distribution(
Column( :NUMERIC_RESULT ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Count Axis( 1 ),
Normal Quantile Plot( 1 )
),
By( :TEST_NAME ),
SendToByGroup(
{:TEST_NAME ==
"Drop_Test"},
SendToReport(
Dispatch(
{
"Distributions TEST_NAME=Drop_Test",
"NUMERIC_RESULT"},
"1",
ScaleBox,
{Min( 0.1 ), Max( 0.49 ), Inc( 0.02 ), Minor Ticks( 1 ),
Add Ref Line( 0.11, Solid, "Red", "LSL", 2 ),
Add Ref Line( 0.48, Solid, "Red", "USL", 2 )}
)
)
),
SendToByGroup(
{:TEST_NAME ==
"Speed_Test"
},
SendToReport(
Dispatch(
{
"Distributions TEST_NAME=Speed_Test",
"NUMERIC_RESULT"},
"1",
ScaleBox,
{Min( LSL + 0.04 ), Max( USL + 0.1 ), Inc( 0.002 ), Minor Ticks( 1 ),
Add Ref Line( LSL , Solid, "Red", "LSL", 2 ),
Add Ref Line( USL , Solid, "Red", "USL", 2 )}
)
)
)
)
)<<report;
```

Please help me on this. Your help is really appreciated!!

2 REPLIES 2

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Need help to populate the correct column value in the distribution graph

@mhalwi,

Maybe this discussion could be helpful to you .

https://community.jmp.com/t5/Discussions/How-to-insert-data-labels-in-graph-builder/td-p/28747

Best

Uday

Uday

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Need help to populate the correct column value in the distribution graph

Hi @uday_guntupalli

i have read the suggestion post that u mentioned above but i can really relate it on how to use it for my script. ill look more in the suggestion for the same issue as this.

thanks

i have read the suggestion post that u mentioned above but i can really relate it on how to use it for my script. ill look more in the suggestion for the same issue as this.

thanks