Salesforce Reports and Dashboards

Data stored in Salesforce is only useful when you can read it, analyze it, and act on it. Reports and Dashboards are the tools that turn raw data into visible insights. A sales manager who checks the pipeline daily, a support lead who monitors case resolution times, and a CEO who watches monthly revenue — all of them use Salesforce reports and dashboards.

What Is a Report?

A Report is a list or summary of Salesforce records filtered and sorted to answer a specific question. Think of it as a smart, saved search that you can run anytime. Examples of business questions a report answers:

• Which opportunities are closing this month?
• How many leads came from the website last week?
• Which sales rep has the highest win rate?
• How many cases are still open and more than three days old?

The Newspaper Analogy

A report is like a custom newspaper page you design once and can print (or view) anytime with up-to-date information. You define the layout, the filters, and the columns — Salesforce fills in the live data every time you open it.

The Four Report Types

Salesforce offers four formats for organizing report data:

Tabular Report

The simplest format — a flat table of rows and columns, like a spreadsheet. Good for lists: "Show me all open leads assigned to me." No grouping, no subtotals. Use it when you need a plain list of records.

Summary Report

Groups records by a specific field and shows subtotals for each group. Example: Group opportunities by Stage and show the total Amount in each stage. This is the most commonly used report type for sales analysis.

  Stage             | Count | Total Amount
  ─────────────────────────────────────────
  Prospecting       |   12  |  ₹24,00,000
  Proposal          |    8  |  ₹36,00,000
  Negotiation       |    4  |  ₹22,00,000
  ─────────────────────────────────────────
  Grand Total       |   24  |  ₹82,00,000

Matrix Report

Groups records by both rows and columns — giving you a two-dimensional view. Example: Rows = Sales Rep, Columns = Month, Values = Total Revenue. This is like a pivot table in Excel.

Joined Report

Combines data from two or more different report types in one view. Example: Show Opportunities and Cases side by side for the same Account. This is an advanced format used less often.

Building a Report: Step by Step

You create reports in the Report Builder, a drag-and-drop tool. Here is the basic flow:

• Step 1: Choose a Report Type — the base object and related objects the report will pull data from (e.g., "Opportunities with Products").
• Step 2: Add Columns — drag fields from the left panel onto the report layout.
• Step 3: Add Filters — narrow the data (e.g., "Close Date = This Quarter", "Stage ≠ Closed Lost").
• Step 4: Group by Field (for Summary or Matrix) — choose which field organizes the rows.
• Step 5: Add Summary Formulas — calculate totals, averages, or percentages.
• Step 6: Save and Run — name the report, choose a folder, and save it.

Report Folders and Sharing

All reports live in Folders. A folder controls who can view or edit the report. You can keep a report private (only you see it), share it with your team, or make it available to everyone in the organization. Report folders are managed through Salesforce's standard folder sharing model.

What Is a Dashboard?

A Dashboard is a visual page that displays multiple reports at once using charts, graphs, and numbers. If a report is a newspaper article, a dashboard is the front page — the most important information shown at a glance.

Each item on a dashboard is called a Component. Each component is powered by a saved report. You choose how that report's data displays — as a bar chart, pie chart, donut, gauge, funnel, or a simple metric number.

  ┌─────────────────┬─────────────────┬──────────────────┐
  │ Pipeline Value  │ Deals by Stage  │ Top Sales Reps   │
  │   ₹1.2 Cr       │  [Bar Chart]    │  [Leaderboard]   │
  ├─────────────────┴─────────────────┴──────────────────┤
  │ Monthly Revenue Trend                                │
  │  [Line Chart — Jan to Jun]                           │
  └──────────────────────────────────────────────────────┘

Dashboard Components

Dynamic Dashboards

A standard dashboard shows the same data to everyone who views it. A Dynamic Dashboard changes based on who is looking at it. When a sales rep opens a dynamic dashboard, they see their own data. When a manager opens the same dashboard, they see the whole team's data. This is useful when a single dashboard needs to serve multiple roles without building separate versions.

Scheduling Reports and Dashboards

You can schedule Salesforce reports and dashboards to be emailed automatically. For example, every Monday morning at 8 AM, the sales manager receives the weekly pipeline summary by email — without logging into Salesforce. This keeps leadership informed without requiring manual steps.

Key Points

• Reports answer specific data questions by filtering and organizing Salesforce records.
• The four report types are Tabular (list), Summary (grouped), Matrix (two-dimensional), and Joined (combined).
• Dashboards display multiple report results visually — charts, gauges, metrics — on a single page.
• Each dashboard component is powered by a saved report and can display data as a bar chart, pie chart, line graph, or number.
• Dynamic dashboards show each user their own data when they view the same dashboard.