The coolest addition to Salesforce reports since drag and drop: Bucket Fields


So what’s the news then? 

This new functionality allows you to group your report results into categories that you define. It is very similar to the “Group” functionality in Excel Pivot Tables. You can:

  • Set logic criteria for numbers (greater than, less than, equal to)
  • Group picklist values (create subgroups on the fly)
  • Group by text fields

Why would I need that?

Because CxO and VP level users don’t want details. They want summaries.  And Bucket Fields allow you to do this in just a few clicks, eliminating the need to write relatively complex logic formulas.

I see, but when do I use it?

When you have a large dataset that would be easier to understand if it was simplified.  A few examples:

Example 1

A report that groups opportunities in Small, Medium and Large (based in amount being smaller than $50k, between $50k and $100k or larger than $100k) by calendar month, giving you a total value for each group.

Image

Example 2

A report that compares your opportunities with your biggest customer (in the example, United Oil & Gas) against the rest of your customer base.

Image

That’s all great, but how do I do it? 

You can use it in all types of reports. My personal recommendation is to use it in a Matrix report, as I am a big fan of displaying as little data as humanly possible to help senior execs reach quick conclusions. For a report to be useful in general, it has to be read and understood in as little time as possible! To add a bucket field to your matrix report, just follow four easy steps:

1.    In your report editor, drag a new bucket field to your table

Image

2.    Choose the field you want to group by

3.    Give the bucket field a name

4.    Add as many groupings as you need (buckets), defining the logic for each of them

Image

I hope you enjoy bucket fields! And remember: It’s all about using them creatively, they offer endless possibilities.

Tagged , , , , , , ,

4 thoughts on “The coolest addition to Salesforce reports since drag and drop: Bucket Fields

  1. Jiri says:

    Good and very comprehensive.

  2. Manan says:

    Thanks.
    It is very helpful.
    But can you tell me is there any limitations on Bucket field?

  3. andrestquila says:

    Hi Manan, and thanks for your comment.

    You are limited to 5 bucket fields in every report, and each of them can contain up to 20 buckets.

    I hope this answers your questions!
    Andres.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: