Loading
Ongoing maintenance for Salesforce HelpRead More
Feature degradation | Gmail Email delivery failureRead More
Analyze Your Data
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Edit a Text Bucket Field

          Edit a Text Bucket Field

          A text bucket helps you sort out values that consist of words or phrases.

          Required Editions

          Available in: Salesforce Classic and Lightning Experience
          Available in: Enterprise, Performance, Unlimited, and Developer Editions
          Available in: Enhanced Folder Sharing and Legacy Folder Sharing
          User Permissions Needed
          To create, edit, and delete reports:
          Legacy Folder Sharing
          Create and Customize Reports

          AND

          Report Builder

          Enhanced Folder Sharing
          Create and Customize Reports

          AND

          Report Builder

          Note
          Note The following text types can’t be bucketed.
          • Text area
          • Text area—long
          • Text area—rich
          • Text area—encrypted
          • URL
          • Date
          • Date/Time

          In the Edit Bucket Field overlay for a text field:

          1. For Source Column, select the field you want to bucket.
          2. Enter a bucket field name. This appears as the column name in the report.
            Since a bucket field is intended to have multiple buckets within it, a good name for a bucket field describes the scope of the buckets. For example, a bucket field named “Region” could have “East,” “West,” and “Central” buckets.
          3. To create a bucket, click New Bucket and enter a bucket name. Create multiple buckets to group your report records.
          4. To find a particular value in the list of values, type all or part of its name in the Search for values... box and click Search, or leave the box empty and click Search.
            The search returns up to 200 values.
          5. Select values and drag them into a bucket. Alternatively, select values, click Move To, and select a bucket or enter a new bucket name.
            While you’re bucketing values, use these functions as needed:
            • Use Enter Values to enter the exact name of a value you want to bucket, or to bucket values that may appear in your report later.
            • To show the values for a particular bucket, click the bucket name.
            • To remove values from a bucket, select the values, select Move To, and select a bucket or enter a new bucket name.
          6. To move all unbucketed values into a bucket named “Other,” enable Show unbucketed values as “Other”. If this is disabled, unbucketed values appear in the bucket column with the value name.
          7. Click OK.

          In a report, text bucket columns are sorted in alphanumeric order.

           
          Loading
          Salesforce Help | Article