cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles