Activity › Forums › Salesforce® Discussions › How are bucket fields used in Salesforce?
-
How are bucket fields used in Salesforce?
Posted by Pooja on April 8, 2020 at 6:21 PMHow are bucket fields used in Salesforce?
Ratnesh replied 6 years, 1 month ago 4 Members · 3 Replies -
3 Replies
-
Bucketing lets you quickly categorize report records without creating a formula or a custom field, Bucket fields can be used like any other field to sort, filter, and group your report. When you create a bucket field, you define multiple categories (buckets) used to group report values.
- [adinserter block='9']
-
Hello Anjali,
Below are the steps to create bucket field in Salesforce report:
1. In the report tab click on the “New Report” button
2. Select a “Lead” or any other object and then create a new report
3. Here you will find the bucket field in the top of list of fields
4. Add this “Bucket Field” into your report
5. Here you will get a popup window called “Edit Bucket Field”. Select the lead status in your source column. Click on the “New Bucket” button, create your criteria field “Open – Working”. Select two criteria “Open And Working” status
6. Move this field into “Open And Working” Criteria
7. Same process for close –converted and closed-Not converted field. Create a “New Bucket Closed” and drag these two closed fields into your closed bucket field. Click “OK” and then select the report as a “Summary Report”
8. Lastly you will get your report which is separated on the basis of “Open-working” and “Closed” status of bucket field -
Bucket field in Salesforce Reports is an incredible powerful functionality used to quickly categorize values for a field in a report without the need to have a custom formula field at the object level.
Log In to reply.