A numeric bucket helps you sort data that can be described in terms of numbers.
|Available in: Salesforce Classic|
|Available in: Enterprise, Performance, Unlimited, and Developer Editions|
|To create, edit, and delete reports:||“Create and Customize Reports”|
In the Edit Bucket Field overlay for a numeric field:
- For Source Column, select the field you want to bucket.
- Enter a bucket field name. This appears as the column name in the report.
Since a bucket field is intended to have multiple buckets (known as “ranges” in numeric bucket fields) within it, a good name for a bucket field describes the scope of the ranges. For example, a bucket field named “Size” could have ranges of “Small,” “Medium,” and “Large”.
- Define your ranges by entering a number and a name. The range names appear as values in your new column.
Each range is greater than the lower number up to and including the higher number.
To remove all ranges and start over, click Clear All.
- To move all empty values to the bucket containing the value zero, enable Treat empty source column values in the report as zeros.
If this is disabled, unbucketed values appear as a dash (-) in the column.
- Click OK.
In a report, numeric bucket columns are sorted by range values.