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:
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.
A report that compares your opportunities with your biggest customer (in the example, United Oil & Gas) against the rest of your customer base.
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
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
I hope you enjoy bucket fields! And remember: It’s all about using them creatively, they offer endless possibilities.