cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Celine1
Level II

Save summary in control chart

Hi, 
I'm using JMP 17. i would like to save a summary in excel file that include product name. 
is it able to phase twice to get another column which is product name?

else
Can advise me how to add another column named product name in the summary?
dt = PT << Save Summaries;

Current Summary

Celine1_1-1699499550554.png

Celine1_0-1699499395801.png


Output that I hope to get is have 3 columns which is Line, Profile Start Time and Product Name

Celine1_2-1699500058486.png

 



1 REPLY 1
SDF1
Super User

Re: Save summary in control chart

Hi @Celine1 ,

 

  Do you know when a product type is being made? For example, are only certain products made during the phases that you show in your control chart? If so, you could make a column formula that is based on IF statements about whether it's Line 1 or Line 2, or Phase 1 or Phase 2 and assign the row value to a certain Product A, B, or C, and so on.

 

  Or, if you have an anonymized data table to share, then it might be easier for someone to generate the analysis you're interested in and save it to the data table and post it back to the thread. Just a thought.

 

Hope this helps,

DS