Band by Rank dialog

Use this dialog to create a band by rank calculation. A band by rank calculation creates a number of bands (e.g. quartiles) and places each value into one of the bands according to its league table position. In other words, each band contains the same number of values. For example, if you have 1000 values you might want to create four bands (i.e. quartiles), each containing 250 values.

Note: If you want to analyze the distribution of values, you might want to use a band by value calculation instead (for more information, see "Band by Value dialog").

For more information, see:

"What are analytic functions?"

"How to create a new calculation using an analytic function template"

"Banding function examples"

Number of bands

Use this field to enter the number of bands into which you want to assign values. For example, type 4 to assign values into quartiles.

Rank based on

Use this drop down list to choose the item for which want to calculate the rank. For example, to calculate the relative position of sales outlets based on sales, you might choose Sales SUM.

Use the adjacent drop down list to specify the ranking order. For example, you might choose Highest Value Ranked 1 if you want sales outlets with the highest sales to be in band 1.

Then rank based on

Use this drop down list to choose an item for which you want to calculate a secondary rank, which is used to determine the rank when two values have the same primary rank (i.e. based on the item specified in the Rank based on field).

Use the adjacent drop down list to specify the ranking order. For example, you might choose Lowest Value Ranked 1 if you want sales outlets with the highest sales and the lowest costs to have the highest league table positions.

Restart banding at each change in

Use this list to specify which groups to use if you want to arrange results into groups (sometimes referred to as partitions).

For example, if you want quartiles for each year, you might choose Calendar Year. In other words, if you have Sales SUM values spanning two years, you will have four bands for each year.

If you do not specify a group, Discoverer treats all worksheet values as a single group.

Calculation

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".