Bucket field lets you quickly categorize report records without the need to create formula or custom field in Salesforce object, when using bucket field you defined multiple categories that are used to group report value.
Bucket field lets you quickly categorize report records without the need to create formula or custom field in Salesforce object, when using bucket field you defined multiple categories that are used to group report value.
For example you want to create incident report based on parent department name (IT/Finance/HR/etc) however the client’s department configured were reflecting the individual sub department name e.g. ITAK/ITUP/ITAM/HRI/HRM/FNTR, so based on this info you want to have a report that shows how many incidents reported from IT, how many from Finance, and how many from HR departments.
You can achieve this report easily by creating bucket fields in your incident report as below.
Step 1 – In the report tab click on the “New Report” button
Step 2 – Select Incident and then click create
Step 3 – Add the fields you want in your report
Step 4 – Add “Bucket Field” and drag it into your report
Step 5 – Here you will get a popup window called “Edit Bucket Field”
Select the client_dept in your source column
Step 6 – Click on the “New Bucket” button and give it a name as IT, HR, Finance.
Step 7 – Search for IT, select all results then move it to IT bucket as below
Step 8 – Repeat for HR and Finance, search for it then select all results then move it to appropriate bucket accordingly so it will become as below
Optionally you can group unbucketed values as “Others”
Step 9 – Change the report type to Summary then drag the bucket field to grouping section as below
Step 10 – Add Chart then choose the chart type e.g. Pie Chart
Step 11 – Run the report