A Bucket Field in Salesforce is a report field that groups values from an existing field into named categories, called buckets. For example, a report can group deals into Small, Medium, and Large, or countries into regions. A Bucket Field exists only inside the report where it was created, not on the object.
PRACTICAL EXAMPLE
A sales manager wants to review deals by size instead of one by one. In an Opportunity report, the manager adds a Bucket Field based on the Amount field with three buckets: Small (up to 1,000),Medium(1,000 to $25,000), and Large (over $25,000). The report can now group, sort, and filter Opportunities by deal size, and no new field is added to the Opportunity object.
Quick Facts
-
Lives inside one report: a Bucket Field is available only in the report where it was created, not on the object. Once added, it works like any other column: you can sort, filter, and group by it.
-
Three bucket types, three ways to build them: numeric buckets use ranges, picklist buckets move existing values into named buckets, and text buckets use the Enter Values button, which helps when the field has a very large number of values.
-
Limits: up to 5 Bucket Fields per report, 20 buckets per Bucket Field, and 20 values per bucket. The total across one Bucket Field is usually capped at around 42 to 45 values. Going over it returns the error “query for these buckets is too complex”.
-
Leftover values:In a picklist bucket, enable “Bucket remaining values as Other” to group all unassigned values into a bucket named Other.
-
Filter caveats: Changing bucket values removes any filters that refer to that bucket column. Filtering by a bucket column also removes the performance benefits of a custom index on its source column.
-
Not supported everywhere: Bucket Fields cannot be created in Historical Trending reports. They are available in reporting snapshots only when the source report is tabular and are not supported in reports that include external objects.
-
Available in Apex: The Reports. BucketField class exposes a bucket’s type, API name, label, source column name, and bucketed values.
Note
A Bucket Field fits one-off grouping. Because it cannot be reused and stops working at around 42 to 45 values, a long list (for example, hundreds of sub-regions) or a grouping needed in many reports is easier to maintain as a Formula Field or a dedicated Picklist field on the object. Salesforce Help suggests a formula field on the object for reuse.
FAQ
Which fields can be bucketed in a Salesforce report?
Salesforce documents three bucketable data types: numeric (currency, number, percent), picklist, and text. Auto number fields cannot go into a numeric bucket. Date fields are not on the list, and the standard Record Type field and Custom Summary Formulas cannot be bucketed either.
Are Bucket Fields available in Salesforce Professional Edition?
No. Salesforce lists Bucket Fields as available only in Developer, Enterprise, Performance, and Unlimited Editions.
Can I use a Bucket Field in more than one report?
No. A Bucket Field works only in the report where it was created. To use the same grouping elsewhere, recreate the bucket in each report, or create a formula field on the object that applies the same logic.
How does a Bucket Field handle blank values?
In a numeric bucket, empty values can be moved into the bucket that contains zero by selecting “Treat empty values in the report as zeroes.” If that option is off, unbucketed values show as a dash. In a picklist bucket, values you leave unassigned can go into a bucket named Other.