Skip to content

Reporting

Reports and dashboards in Salesforce

How to build reports and dashboards in Salesforce that show you every day how your KPIs are doing.

Reading time
2 min
Published
Updated
All articles

What is a report? A filtered, grouped overview of data with totals and formulas. Suited for analysis and for drilling down into details.

What is a dashboard? A visual set of components (tiles, charts, tables) that shows your KPIs at a glance.

What does it give you? Seeing in real time whether you are on track, less manual work, and decisions based on facts instead of gut feeling.

What do we mean by reports and dashboards?

Reports and dashboards are closely related, but serve different purposes. Reports deliver the details and calculations; dashboards show at a glance where you need to adjust. How we set them up is described under reporting and process automation.

Think of a cockpit: the report is the measuring instrument under the hood, the dashboard is your control panel with gauges and traffic lights.

Good to know

Salesforce Lightning has several types of dashboard components, such as a bar chart, a line chart, a gauge, a single metric and a table. For each KPI you choose the view that fits best.

What does your organization get out of it?

A sales manager wants to know daily how the team is performing, but only gets Excel overviews that are weeks old. Result: steering on gut feeling and lots of manual work.

  • Faster insight: current KPIs without exporting.
  • Less manual work: one source and reusable reports.
  • Real-time KPIs: targets, trends and alerts on one screen.

The building blocks of reports and dashboards

Reports

Choose a report type, filter and group. Add summary formulas for KPIs.

Dashboard Components

KPI tiles, charts and tables. Each component is linked to one report.

Filters

Report filters limit the data; dashboard filters let users switch views on the fly.

Lightning Experience

Build visually: drag, resize and see the result right away, with responsive layouts.

Practical example: from data to dashboard

Scenario: the sales manager wants to see current revenue against target every day, per region.

1. Create the report

  • Go to Reports, choose New and pick the "Opportunities" report type.
  • Filters: Stage = Closed Won; Close Date = Current Quarter.
  • Group by Region and show SUM(Amount).
  • Optional: formula "% of target".

2. Build the components

  • KPI tile "Total Revenue QTD".
  • Bar chart "Revenue per region (QTD)".
  • Line chart "Revenue per week (trend)".

3. Add dashboard filters

  • Filter on Region.
  • Optional: Team or Opportunity Owner.

4. Share with your team

  • Folder "Sales Management" with Viewer permissions.
  • Add it as a tab or pin it as a favorite.

Best practices and tips

Do's

  • Use consistent definitions and measurement moments.
  • Give clear names: "Service SLA | Month | NL".
  • Limit yourself to 6 to 8 components per dashboard.
  • Schedule monthly reviews with stakeholders.

Don'ts

  • Duplicate KPIs per person; use filters.
  • Keep targets outside Salesforce.
  • Creating more and more variants without agreements on who may change what.

Common mistakes

  • Overcrowded dashboards: core KPIs get buried.
  • Different definitions per team: numbers not comparable.
  • Targets missing in Salesforce: progress against goal is invisible.

Common dashboards

  • Sales pipeline. Stages, expected revenue, win rate and cycle times, from your Sales Cloud setup.
  • Service performance. SLA, first-call resolution, resolution time and backlog.
  • Marketing. Leads, MQLs, conversion to opportunity and ROI.
  • C-level KPIs. Revenue, margin, churn/retention, NPS/CSAT and forecast.

Want better insights with reports and dashboards?

We help you define KPIs, set up dashboards and organize reports, so your team steers on the numbers in Salesforce.

Schedule a reporting session