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: A custom query for Length of Stay data
Viewed 2511 times since Fri, Nov 9, 2007
CR: Charting pass-fail data as a p-chart
Viewed 4450 times since Fri, Feb 29, 2008
CR: CR1.1 - Notes and Causes Problem
Viewed 2087 times since Fri, Nov 9, 2007
CR: Unable to fully display settings and windows
Viewed 1919 times since Fri, Jan 22, 2010
CR: Show every date on the chart
Viewed 2216 times since Thu, Jan 31, 2008
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2067 times since Fri, Nov 9, 2007
CR: CR1.5 - My control chart data lines are not printing
Viewed 2183 times since Fri, Nov 9, 2007
CR: Grouping counts by date in Excel
Viewed 2170 times since Fri, Nov 9, 2007
CR: Bar Chart of a column of numbers in various categories
Viewed 1964 times since Fri, Nov 9, 2007
CR: CHARTrunner and SharePoint
Viewed 3970 times since Fri, Mar 9, 2012