Use this dialog to create a band by value calculation. A band by value calculation creates several bands (sometimes referred to as buckets) and places each value into one of the bands according to the value. In other words, each band can contain a different number of values. For example, you might want to know how sales values are distributed over bands $0 to $49, $50 to $99, $100 to $150.
This type of analysis is sometimes referred to as frequency distribution.
Note: To create bands containing an equal number of values (for example, quartiles), you might want to use a band by rank calculation instead (for more information, see "Band by Rank dialog").
For more information, see:
"What are analytic functions?"
"How to create a calculation using an analytic function template"
Use this field to enter the number of bands into which you want to assign values. For example, type 4 to assign values into four bands.
Note: The range of each band is calculated as the maximum value in the group minus the minimum value in the group divided by the number of bands.
You can override the default maximum and minimum values using the Highest value and Lowest value fields.
Use this drop down list to specify which worksheet values you want to put into bands. For example, choose Sales SUM to divide sales totals into several bands.
Use the adjacent drop down list to specify the banding order. For example, you might choose Highest Value in Band 1 if you want stores with the highest sales to be in band 1.
Use this field to specify a minimum value that is different from the minimum value in the group. You must clear the Use minimum value check box to activate the Lowest value field.
For example, you might have a wide range of sales figure with a minimum value that is exceptionally low. You might want to exclude the exceptionally low value from the lowest band.
If you select the Use minimum value check box, Discoverer specifies the minimum value for you.
Use this field to specify a maximum value that is different from the maximum value in the group. You must clear the Use maximum value check box to activate the Highest value field.
For example, you might have a wide range of sales figures with a maximum value that is exceptionally high. You might want to exclude the exceptionally high value from the highest band.
If you select the Use maximum value check box, Discoverer specifies the maximum value for you.
Restart banding at each change in
Use this list to specify which groups to use to arrange results into groups (sometimes referred to as partitions).
For example, to analyze the distribution of sales across each year, you might choose Calendar Year. In other words, if you have Sales SUM values spanning two years, you would have a set of bands for each year.
If you do not specify a group, Discoverer treats all worksheet values as a single group.
This read-only field displays the underlying formula that you are building as you specify values for the fields above. This formula is updated each time you change one of the values in the fields above. When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".