topic Re: Control Chart Builder with source data from multiple columns in Discussions

Control Chart Builder with source data from multiple columns

sbiedrzycki — Mon, 09 Apr 2018 20:23:07 GMT

I like the visualization provided by the Control Chart Builder. In particular I like the stacked Xbar-R plots in one figure, the built-in distribution with normal distribution fit overlay, and automatic control limits calculated overlaid on the charts. Unfortunately, many different data sources I'm working with aren't entered in full to our JMP tables. Mean, range and standard devivation are calculated at the source and only these final values are entered into our tables due to limitations in automation at the moment.

I would like to use this data in building the control charts so that I can have a full Xbar-R or Xbar-S chart with the data from these source columns. I've not had luck figuring out a way to do this - I can only get it to plot as an individual measurement with a moving range. Is there a way that I can point it to the mean and range/standard deviation data columns to construct the charts from these sources? Or will I have to write a custom script to mimic these plots?

I am somewhat familiar with JSL and could work through a script for this but it seems like it would be far more involved especially given the need to support many different data sources. Being able to assemble the charts in the builder would be more user friendly for everyone on the team to work with.

Thanks,

Steve

Re: Control Chart Builder with source data from multiple columns

cwillden — Tue, 10 Apr 2018 02:18:51 GMT

Hi @sbiedrzycki,

That's an interesting question. I don't think that is an existing capability, but you can probably twist JMP's arm into doing what you want if you know how to compute the control limits yourself. I imagine you have the means and standard deviations in separate columns. You could do separate individuals charts on the means and standard deviations with custom control limits that you input into a control limits column property. You just need to make sure to set the control limits for an individuals chart for both the mean and the standard deviation column.

Here's an example where I generated some individuals in groups of 5. I created the control chart on the right with that data. Then I did a summary to compute the mean and standard deviation for each subgroup. In the summary table I input the correct control limits (again, you'll need to know the formulas to compute these on your own). I was able to then create the control chart shown on the left from this table. The charts are effectively the same.

I'm attaching the summary table so you can see how I input the control limits in column properties. In Control Chart Builder, you'll need to remove the moving range chart (right-click in the mR chart area > Remove, not "Remove Graph"). To add the individuals chart for the standard deviation column, select it and press "New Y Chart".

Re: Control Chart Builder with source data from multiple columns

sbiedrzycki — Tue, 10 Apr 2018 20:37:44 GMT

@cwillden

That's better than I was able to get through trial and error. I wasn't able to figure out how you constructed the plot though. Was that through the chart builder directly or did you do it by writing the JSL yourself? I'm just wondering if I'm missing something or is there hidden functionality that is only accessible through directly writing JSL.

I'm not able to get it to add the capability analysis to the charts however. Neither ticking the menu option in the window nor modifying the JSL script to have Show Capability marked as 1 has any effect. Nothing is added to the plot even with dummy spec limits filled in for the column properties.

I can only get it if I go through the builder and pull in the data directly... but that goes back to my original problem being unable to link the Std Dev. column for the lower plot.

Re: Control Chart Builder with source data from multiple columns

cwillden — Thu, 12 Apr 2018 16:00:59 GMT

Hi @sbiedrzycki,

Here's a video of how I made the plot. No JSL required:

(view in My Videos)

To get the capability analysis, you would need to add the spec-limits as another column property. Just note that capability will be computed with respect to your subgroup averages, not individuals.

Re: Control Chart Builder with source data from multiple columns

sbiedrzycki — Fri, 13 Apr 2018 12:32:04 GMT

Oh ok! I didn't realize I could remove the graph like that. It took a bit of wrestling with the column properties but I was able to get the capability analysis. I'm close. I would still like to figure out how I could merge those two graphs to waste less screen space. I'll probably play around with the raw script a bit to see if that might be possible with direct manipulation of what I have so far.