Ranges and Quantiles

Click the Range button next to one of the Summation Options to create a range or quantile based on that summation option:

The field list showing available summation options and the mouse pointer hovering over the Range button

The Range dialog displays:

The Range dialog

You can choose either to create a series of custom ranges or create your ranges using one of the predefined quantiles:

Custom Ranges

To define a series of custom ranges you need to specify the lowest and highest values in the range and an increment. SuperWEB2 will automatically create a series of ranges between the two values, with each individual range the size of the increment.

When defining the range, you need to specify what to do with values that are equal to one of the range boundaries: use the drop-down lists to select either < or  for the From or To value.

When you have completed all the options, click Next. SuperWEB2 then displays the ranges you are about to create, and you can either click Create to create them, or Back to make changes.

Example 1 - Include the Upper Boundary in the Range

If you set the values to:

  • From: 100 <
  • To: 1000 ≤
  • Increment: 100

The Range dialog showing a range called Customer Profit Range defined as greater than 100 to less than or equal to 1000 in increments of 100

SuperWEB2 creates ranges where each range includes values that are equal to the upper range boundary:

A defined range including the buckets 100 or less, More than 100 to 200, More than 200 to 300 and so on up to More than 900 to 1,000 and More than 1,000

Example 2 - Include the Lower Boundary in the Range

If you set the values to:

  • From: 100 ≤
  • To: 1000 <
  • Increment: 100

The Range dialog showing a range called Customer Profit Range defined as greater than or equal to 100 to less than 1000 in increments of 100

SuperWEB2 creates ranges where each range includes values that are equal to the lower range boundary:

A defined range including the buckets less than 100, 100 to less than 200, 200 to less than 300 and so on up to 900 to less than 1,000 and 1,000 or more

When you click Create, your range is added to the Ranges section in the customise table panel:

A defined range showing in the field list that includes the buckets less than 100, 100 to less than 200, 200 to less than 300 and so on up to 900 to less than 1,000 and 1,000 or more

Now that you have created your range, you can add the ranges to a table.

You cannot edit the range once you have created it, but if you click Manage you can use the Clone option to create a new range based on the existing one. You can also use the Manage function to delete the range.

The system administrator may have set limitations on ranges that set the minimum From value, the maximum To value, and the minimum Increment. If you attempt to create a range that breaches the configured limits then you will see an error message, and you will need to adjust your range accordingly.

Quantiles

To create a series of ranges using quantiles:

  1. Select the Quantile tab.
  2. In the Name field, enter a name for your new series of ranges (up to 25 characters long).
  3. In the Number of ranges drop-down list, select the number of ranges you want to create. The available options will depend on how the administrator has configured the quantile settings for this dataset. For example:

    The Range dialog with the Quantile tab selected and the drop-down list showing available quantiles Median, Tercile, Quartile, Quintile, Sextile, Septile, Octile, Nonile, Decile

  4. In the Equal Distribution drop-down list, select whether you want to construct the quantile ranges using the summation option or a record count.

    For example:

    Create four ranges based on an equal distribution of the Customer Profit summation option:

    The Quantile tab with Quartile and an equal distribution of Customer Profit selected

    Create four ranges based on a equal distribution of the number of records in the Customers table:

    The Quantile tab with Quartile and an equal distribution of Customers selected

  5. (Optionally) apply a filter:

    1. Select some fields from the list on the left.
    2. Click Move to add them to the list on the right.

    With a filter in place, the quantile will only be constructed from records that match the specified field values. For example the following quantile will only contain records for Male customers who do one of the three specified occupations:

    The Quantile tab with Quartile and an equal distribution of Customers selected, and field items from Occupation and Gender added to the filters

  6. Click Next to review the quantile ranges.
  7. You can then click either Create to create the ranges, or Back to make changes.

    The Range dialog showing a summary of the user's selected options for the range being defined

    You can also click Download to save a copy of the quantile definition in CSV format.

  8. When you click Create, your quantile is added to the Ranges section in the customise table panel:

    The defined range buckets added to the fields list