+44 203 280 3665

When is a report not a report? When it doesn’t give the viewer the information she’s looking for – quickly and easily.

Since our blog on the “10 sales and pipeline charts that should be on your Salesforce dashboard” a number of people have asked why we insist upon on Matrix reports rather than Summary reports. After all, Summary reports are slightly easier to build than Salesforce matrix reports. Well here’s why!

Take a look at the dashboard chart below. It’s #2 on our 10 charts that should be on your Salesforce dashboard. It shows the sales pipeline summarised by Close Date and Opportunity Stage.

Example of a salesforce dashboard chart built using either a matrix report or a summary report.

It’s one of the fundamental components for any effective sales dashboard. We’ve created a video that explains the full power of this chart and demonstrates how to create it using a matrix report.

But here’s the key thing. This same dashboard chart can be created using either a Matrix or Summary report in Salesforce. So why both to make the small about of extra effort to create it as a matrix report?

Let’s drill down to the underlying report. Here’s what you get when it’s configured as a matrix report.

Example of a salesforce matrix report

But look what happens when the same report is built as a Summary report.

Example of a summary report in salesforce

In the interests of size we’ve had to leave off the bottom half of the report from the screenshot. But it’s the exact same information that’s shown in the matrix report, just in a format that’s a lot harder to read and assimilate.

Clearly the Matrix report gives a much better and more immediate picture of what’s going on. And you get to see the whole set of information in one easy-to-view screen. Watch this video for a full demonstration of the benefits of matrix reports and see exactly how to create one.

A Matrix report doesn’t suit every single situation – but if in doubt, start with a Matrix report. Don’t forget to look at 10 charts that should be on your Salesforce dashboard to see some other great examples of matrix reports in action. Or take a look at 10 best practice tips for awesome Salesforce dashboards.

And finally, here’s Gary explaining the power of Salesforce dashboard chart #2 and demonstrating how to create it using a matrix report.

12 Must Have Charts For Your Salesforce Dashboard

Download the FREE eBook today from our website

Related Blog Posts

The Ultimate Guide To Campaigns In Salesforce | With Examples

The Ultimate Guide To Campaigns In Salesforce | With Examples

This article is a complete guide to using Campaigns in Salesforce. In this expert-written guide you'll learn all about: The essential features of Salesforce Campaigns. How to create and customize Campaigns in Salesforce. How to use Campaign Members. Syncing marketing...

Popular Apps

GSP Target Tracker

Track targets in Salesforce including won and pipeline deals

Popular eBook

Download The 12 Must-Have Dashboard Charts

This fully-illustrated 27 page ebook shows you the 12 Killer Sales Charts for your Dashboard and explains How to Read Them and When to Use Them.

Related Blog Posts

Why You Need To Compare Average Closed Won Opportunity Size

How to use opportunity conversion reports for superior results

How To Stop ‘Closed Lost’ Screwing Up Salesforce Dashboards

5 Easy Tips That Will Make Opportunity Probability Your Trusted Friend

Share This