Home » Categories » CHARTrunner

CR: Largest Subgroup Size Supported by CHARTrunner

Revision Date: 2005-09-19

Problem:

What is the largest subgroup size supported by CHARTrunner?

Solution:

When you define an X-bar chart, on the data definition tab, you may map up to 40 measurement columns. This will result in a chart where each data point is the average of 40 columns of data. So the general answer is that 40 is the largest subgroup size supported.

However, there is an exception; when you use advanced row selection and you use the option to form subgroups whenever a column changes (we call this grouping) you cannot predict ahead of time how many rows might fall into each group. In this case the first 30 rows might form the first subgroup (imagine this is January) the second 27 rows might form the next subgroup (imagine this is February) - then imagine that March contained 80 rows. In this case the subgroup size is variable. The first point on the chart is the average of 30 rows - the second point on the chart is the average of 27 rows - the third point on the chart is the average of 80 rows. In this case the subgroup size of 80 will work. When you do advanced row selection/grouping - the largest subgroup size we support is 100. If any grouping results in more than 100 rows – an error message will be generated.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2065 times since Fri, Nov 9, 2007
CR: Grouping counts by date in Excel
Viewed 2115 times since Fri, Nov 9, 2007
CR: Making an X-bar chart with a single data column
Viewed 2028 times since Fri, Nov 9, 2007
CR: Data grouping tardiness
Viewed 3098 times since Tue, Oct 6, 2009
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 3953 times since Wed, Oct 14, 2009
CR: CHARTrunner and Open Office
Viewed 2338 times since Fri, Nov 9, 2007
CR: Histogram bars beyond specification lines
Viewed 2268 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2152 times since Fri, Nov 9, 2007
CR: Label your X-Axis with more than one identifier
Viewed 2471 times since Tue, Oct 6, 2009
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2057 times since Fri, Nov 9, 2007