cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
%3CLINGO-SUB%20id%3D%22lingo-sub-802648%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EForce%20stacking%20of%20control%20charts%20in%20Control%20Chart%20Builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802648%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIs%20there%20any%20way%20to%20force%20stacking%20of%20control%20charts%20using%20%22by%20variables%22%20as%20shown%20in%20the%20example%20below%3F%20Weirdly%2C%20when%20applied%20to%20my%20original%20table%20(not%20anonymized)%2C%20the%20control%20charts%20appear%20all%20in%20one%2C%20horizontal%20row%20with%20a%20long%2C%20long%20scroll%20bar.%20I%20want%20what%20is%20shown%20below.%20Possible%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ressel_0-1727694728883.png%22%20style%3D%22width%3A%20315px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68704i014C6C5766CB5B25%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ressel_0-1727694728883.png%22%20alt%3D%22Ressel_0-1727694728883.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-802648%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EQuality%20and%20Process%20Engineering%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802690%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Force%20stacking%20of%20control%20charts%20in%20Control%20Chart%20Builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802690%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15435%22%20target%3D%22_blank%22%3E%40Ressel%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20I%20use%20control%20chart%20builder%20(v18)%20and%20use%20'New%20Y%20chart'%20and%20select%20all%20of%20the%20columns%20they%20stack%20similar%20to%20what%20you%20have%20described%20(minus%20the%20unique%20grey%20'headers')%20-%20is%20that%20what%20you're%20looking%20for%3F%20I've%20attached%20the%20data%20table%20with%20the%20script%20to%20recreate%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68719iF5ACD39980AAD99D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ben_BarrIngh_1-1727701754841.png%22%20alt%3D%22Ben_BarrIngh_1-1727701754841.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68718iE7713CB15F40A69D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ben_BarrIngh_0-1727701643994.png%22%20alt%3D%22Ben_BarrIngh_0-1727701643994.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20version%20are%20you%20on%3F%20Are%20you%20hoping%20for%20a%20scripted%20solution%20or%20manual%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EBen%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802724%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Force%20stacking%20of%20control%20charts%20in%20Control%20Chart%20Builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802724%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThanks!%20Yet%2C%20I%20forgot%20to%20mention%20that%20my%20table%20is%20stacked.%20Think%20of%20the%20same%20QC%20test%20sample%20measured%20in%20association%20with%20different%20products.%20So%2C%20I%20can't%20use%20the%20%22New%20Y%20Chart%20button%22%2C%20unless%20the%20table%20is%20split%2C%20which%20I%20don't%20want%20to%20do.%26nbsp%3BI%20want%20one%20control%20chart%20per%20product%20type%20A%2C%20B%20and%20C.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EProduct%3C%2FTD%3E%3CTD%3EQC%20check%20sample%20result%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3E0%2C22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3E0%2C06%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E0%2C94%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E0%2C10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E0%2C07%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E0%2C11%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E0%2C59%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E0%2C21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E0%2C82%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Force%20stacking%20of%20control%20charts%20in%20Control%20Chart%20Builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15435%22%20target%3D%22_blank%22%3E%40Ressel%3C%2FA%3E%26nbsp%3B%2C%20got%20you.%20In%20that%20case%2C%20you%20can%20go%20directly%20to%20the%20IMR%20chart%20option%20in%20the%20sub-menu%20then%20use%20the%20'By'%20option%20to%20create%20individual%20stacked%20charts.%20It%20comes%20out%20stacked%20as%20default%20for%20me.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ben_BarrIngh_0-1727705010212.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727705010212.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727705010212.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_0-1727705010212.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68724iDE94F07F178153D8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ben_BarrIngh_0-1727705010212.png%22%20alt%3D%22Ben_BarrIngh_0-1727705010212.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ben_BarrIngh_1-1727705045070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727705045070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727705045070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_1-1727705045070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68725iA3A662872222CAE7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ben_BarrIngh_1-1727705045070.png%22%20alt%3D%22Ben_BarrIngh_1-1727705045070.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ben_BarrIngh_2-1727705060370.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_2-1727705060370.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_2-1727705060370.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ben_BarrIngh_2-1727705060370.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68726iC23719CB709F7CFE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ben_BarrIngh_2-1727705060370.png%22%20alt%3D%22Ben_BarrIngh_2-1727705060370.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802757%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Force%20stacking%20of%20control%20charts%20in%20Control%20Chart%20Builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802757%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EYes%2C%20that's%20the%20approach%20I've%20been%20using%2C%20but%20doesn't%20work%20on%20my%20non-anonymized%20table.%20That's%20why%20I%20want%20to%20know%20whether%20this%20can%20be%20forced.%20Can%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20there's%20a%20difference%20between%20my%20anonymized%20and%20non-anonymized%20tables%2C%20perhaps%20the%20issue%20is%20related%20to%20string%20length%20of%20the%20process%20names%20or%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Ressel
Level VI

Force stacking of control charts in Control Chart Builder?

Is there any way to force stacking of control charts using "by variables" as shown in the example below? Weirdly, when applied to my original table (not anonymized), the control charts appear all in one, horizontal row with a long, long scroll bar. I want what is shown below. Possible?

Ressel_0-1727694728883.png

 

4 REPLIES 4

Re: Force stacking of control charts in Control Chart Builder?

Hi @Ressel,

 

When I use control chart builder (v18) and use 'New Y chart' and select all of the columns they stack similar to what you have described (minus the unique grey 'headers') - is that what you're looking for? I've attached the data table with the script to recreate it.

Ben_BarrIngh_1-1727701754841.png

 

Ben_BarrIngh_0-1727701643994.png

 

What version are you on? Are you hoping for a scripted solution or manual?

 

Thanks,

Ben

 

 

“All models are wrong, but some are useful”
Ressel
Level VI

Re: Force stacking of control charts in Control Chart Builder?

Thanks! Yet, I forgot to mention that my table is stacked. Think of the same QC test sample measured in association with different products. So, I can't use the "New Y Chart button", unless the table is split, which I don't want to do. I want one control chart per product type A, B and C. 

 

ProductQC check sample result
A0,22
A0,06
B0,94
B0,10
B0,07
C0,11
C0,59
C0,21
C0,82

 

Re: Force stacking of control charts in Control Chart Builder?

@Ressel , got you. In that case, you can go directly to the IMR chart option in the sub-menu then use the 'By' option to create individual stacked charts. It comes out stacked as default for me.

Ben_BarrIngh_0-1727705010212.png

Ben_BarrIngh_1-1727705045070.png

 

Ben_BarrIngh_2-1727705060370.png

 

 

 

“All models are wrong, but some are useful”
Ressel
Level VI

Re: Force stacking of control charts in Control Chart Builder?

Yes, that's the approach I've been using, but doesn't work on my non-anonymized table. That's why I want to know whether this can be forced. Can it? 

 

Since there's a difference between my anonymized and non-anonymized tables, perhaps the issue is related to string length of the process names or something?