Tag Archives: reports

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 Continue reading

Tagged , , , , , , ,
Follow

Get every new post delivered to your Inbox.

Join 49 other followers