How to Create Bucket Fields in your Report in Remedyforce

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

 

 

 

Posted in Blogs.