Skip to main content
Skip table of contents

ranges

custom range and quantile user defined fields
UsageDescription
ranges <dataset_id>

Display the limits currently defined for the specified dataset.

For example:

CODE
> ranges bank
Customer Profit:
    custom range: 10.0, 10000.0, 100.0
Account Profit:
    custom range: [min], [max], [min-increment]
Average Account Balance:
    custom range: [min], [max], [min-increment]

In this example:

  • The Customer Profit summation option has range limits defined. SuperWEB2 users will not be able to create custom ranges or quantiles with a From value that is lower than 10, a To value that is higher than 10,000 or an Increment smaller than 100 (the increment limit does not apply to quantiles).
  • Account Profit and Average Account Balance do not have any limits set.
ranges <dataset_id> <field_or_regex>

Display any range limits currently defined for the specified summation option.

You can either specify the summation option using its display name, or you can specify a regular expression and SuperADMIN will display the limits for all matches. For example:

CODE
> ranges bank .*Account.*
Account Profit:
    custom range: [min], [max], [min-increment]
Average Account Balance:
    custom range: [min], [max], [min-increment]
ranges <dataset_id> <field_or_regex> custom <min> <max> <min_increment>

Apply a limit to the specified summation option (or any summation options matching the regular expression).

You can specify:

  • The minimum From value.
  • The maximum To value.
  • The minimum Increment size.

The limits apply to both custom ranges and quantiles, although the increment does not apply to quantiles.

For example, the following command sets custom ranges for the "Customer Profit" field in the bank dataset:

CODE
ranges bank "Customer Profit" custom 10 1000 100
ranges <dataset_id> <field_or_regex> custom clear

Clear the custom range from the specified summation option (or any summation options matching the regular expression).

For example:

CODE
> ranges bank .*Account.* custom clear

To clear all custom ranges for a particular dataset, you can use the regular expression .*

For example, the following command would clear all custom ranges defined for the bank dataset:

CODE
> ranges bank .* custom clear
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.