---
schema_version: "1"
id: de6b3a9b9c917a66f3ca0a5aa35d0dbb4ddf84552a4f93fb28cd96de48e8cdc1
title: Edit a Numeric Bucket Field
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_bucketing_numeric.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_numeric.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c279781369890a556f57a3f5e12fdc218319d0cf3b6a535a9c78d49d9bf3ce65
description: A numeric bucket helps you sort data that can be described in terms of numbers.
products:
  - Cross Cloud
release: "264"
---
# Edit a Numeric Bucket Field

A numeric bucket helps you sort data that can be described in terms of numbers.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing and Legacy Folder Sharing</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d67042e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d67042e78 ">To create, edit, and delete reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d67042e78 ">
              <p>Legacy Folder Sharing</p>
              <p>AND</p>
              <p>Create and Customize Reports </p>
              <p>Report
                Builder</p>
              <p>Enhanced Folder Sharing</p>
              <p>Create and Customize Reports
              </p>
              <p>AND</p>
              <p style="margin-bottom:0;">Report Builder</p>
            </td>

          </tr>
        </tbody>
      </table>

In the Edit Bucket Field overlay for a numeric field:

1. For Source Column, select the field you want to bucket.
2. Enter a bucket field name, which appears as the column name in the report.
    
    A bucket field is intended to have multiple buckets (known as “ranges” in numeric bucket fields) within it. A good bucket field name describes the scope of the ranges. For example, a bucket field named “Size” could have ranges of “Small,” “Medium,” and “Large”.
3. 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**.
4. 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 setting is disabled, unbucketed values appear as a dash (-) in the column.
5. Click **OK**.

In a report, numeric bucket columns are sorted by range values.

#### See Also

- [Numeric Bucketing Example: Deal Size](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_numeric_example.htm&release=264.0.0&type=5 "To gain insight into your deals, use bucketing to group by deal size instead of looking at individual deals. This lets you concentrate on the large deals that affect your quota the most.")