36182_en-US

liliconcom

Cannot create P control chart

I have a script that imports production data, manipulates it, and then creates three control charts to monitor nonconformace rates in three different departments. Lately when I run the script it will only create two of the control charts. When I try to create the third one manually it gives the error "For P Chart, data should either be proportions and counts, but not both." I double checked the data set for anonolies, but it looks fine and all the values are proportions, in decimal form or 0, and less than 1 similar to the data for the other two control charts. What's odd is that if I copy and paste the data into a new column and use that to create the control chart there are no issues. I've attached a copy of the data set in question and here's the section of the script regarding the control charts:

//********************Create Dry Production Control Chart********************//

//Set SM as current data table
SM << Current Data Table();

//Create a subset of SM of all the Dry Production data - Dry Production Subset (DP)
SM << Select Where( :DEPT Group == "Dry Production");
DP = SM<<SUBSET></SUBSET>

Re: Cannot create P control chart

Thanks! I didn't notice that data point. I'll try switching my control charts to control chart builder.

Re: Cannot create P control chart

It is becasue row 192 has a value of 1.14852492370295 for NC Rate.  The check for proportional versus counts is done on the entire data set and not just the unexcluded observations.  You should use Control Chart Builder instead of the old P chart platform.  Control Chart Builder does not have this issue.  Otherwise, you can delete row 192 and then the chart will be created as you expect.

Re: Cannot create P control chart

I forgot to mention it is the Dry Production control chart that is not being created correctly.