How to Create Reports and Build Dashboards in Salesforce

Salesforce: How to Create Dashboards and Reports Step-by-Step Tutorial
5/25/2023
·
3 min. read

Nowadays when business becomes more tech-oriented and fast-paced, data analysis plays an increasingly important role. Salesforce offers you some essential analytical tools to bring more benefits to your business.

What are Salesforce reports

Salesforce reports together with dashboards are a part of analytical tools that aims to provide you with the most relevant information about your data and make the information more user-friendly.

Salesforce report presents a list of filtered records that can be used for organizations of all types and sizes.

sales1.png

Example of Salesforce report

How to create a Salesforce report

Salesforce has visual tools that help to create and edit reports, where you can choose a type, a format, and all the necessary fields. It also has different filters and all the reports can be customized as per users' requirements.

There are two main types of reports:

  • Standard reports include standard objects and can not be customized.
  • In customized reports we can specify the object to be included.

There are four types of customized reports:

  • Tabular.
  • Summary.
  • Matrix.
  • Joined.

Tabular reports

It is the basic format, similar to Excel. It is a row of data with a grand total. It can not be used to create charts of groups of data, it is a simple list or a list with a grand total. If you need to export data it is the best type.

How to create tabular reports:

  1. Launch the app, click the New Report button, then select the object/s you want to report on (you can use a search bar) and click Continue.
  2. Then you need to select your filters in the “Filters” tab. If “Update Preview Automatically” is turned off, you need to refresh it to see the correct results.
  3. Then click the “Outline” tab and choose the fields to be displayed. Remove the unnecessary fields by clicking the “X” and adding your own fields. Press Refresh if you need to see the updated information. Click “Save & Run”.

Summary reports

It is a very popular report type. It gives you an option of data grouping, creating charts and viewing subtotal. When adding a grouping to an existing field we can just drag the field from columns to group rows if it is already on the layout, or you can start typing the field name in “Add group” and select it. After hitting “Save & Run” we get the new type of report.

Matrix reports

It is a summarized type of report. It allows to group data by rows and columns to see totals. You can add charts and generate dashboards with the Matrix reports. Add another grouping, this time a “Group Column” and “Group Rows” to display more information in your report. Press “Save & Run” to get a Matrix-type report.

Joined reports

This type allows the building of two separate reports to compare data. It is arranged in blocks and each block has its columns, fields, sorting, and filtering. So, it can show data from different views and from different report types.

Salesforce report features

Salesforce is constantly adding new features that help to improve analytics, adding value to the application and making it more effective. Among useful Salesforce features you can find:

  • Custom report types. While creating your report, you may need to go beyond auto-created or standard reports, in case you need to report on more than 2 objects at one time. For this, you can use complex reports and choose only related objects to be included.
  • Summary formulas. Summary formulas can handle complex calculations at all summary levels, acting like fields once formulas are created. They go across multiple records and can be used for comparing data, groupings, or calculations.
  • Row-Level Formulas. They are often confused with Summary formulas, but the main difference is that they are used for a single record, for example in a column-based formula that shows the result on the row.
  • Field to Field Filters. This option is used to compare data in different fields. All you need is to specify the fields to be included. The results will be filtered by your selected criteria.

How to schedule a Salesforce report

You can schedule receiving reports daily, once a week, or a month. Also, you can subscribe yourself or/and other users and choose what exactly should be shown in the report for each person. You will receive it via email and should have access to the folder where it will be stored.

What are dashboards in Salesforce and their components

Dashboards are visual displays that get all the information from a linked database. The main components include metrics, tables, charts, etc. Salesforce has an intuitive interface that helps you to create dashboards from Standard or Custom reports.

sales2.png

Example of Salesforce dashboard

Among the main dashboard components you can find:

  • Charts are used to visualize data. You can choose between different types like bar or pie, line, or column to communicate your information clearly and efficiently.
  • Gauges are normally used to visualize data having only a single value. They are not used for multiple rows, but can display multiple measure values.
  • Metrics are used when you have one main value to display. They are mostly used for tracking performance and production, for comparing and evaluating.
  • Tables present lists of data in columns and can be used to summarize information or explain variables.

Conclusion

Building dashboards in Salesforce can help you with many aspects. These analytical tools allow you to understand from basics like what was the income for the last week to knowing your top performers and identifying the most successful campaigns. That can be very helpful in order to develop the best strategies and promote your business.


Related articles

Show more
Best CRM Software Solutions to Boost Your Business in 2025
Salesforce
5 min. read

Best CRM Software Solutions to Boost Your Business in 2025

In this article, you will learn about the best CRM software solutions that will help you track leads, deals, and communicate with customers.

Top-Rated SaaS Platforms for Customer Communication in 2025
5 min. read

Top-Rated SaaS Platforms for Customer Communication in 2025

In this article, you will discover the top 10 SaaS solutions for streamlined customer support, chatbots, live chat, and more! Enhance engagement and drive conversions in 2024.

What Are the Best Platforms for Salesforce Integration
Salesforce
3 min. read

What Are the Best Platforms for Salesforce Integration

In this article, we’ll explore some of the best platforms for Salesforce integration, and why businesses of all sizes should consider using them—especially if they want to get more out of their Salesforce investment.

Albato Data Storage: Integrate HubSpot and Salesforce by ID entities
Salesforce
5 min. read

Albato Data Storage: Integrate HubSpot and Salesforce by ID entities

In this article, you will learn how to use Albato Data Storage to integrate two CRM systems by linking ID entities across platforms.

How to Use Albato Email Automation for Better Communication
Salesforce
4 min. read

How to Use Albato Email Automation for Better Communication

Automate your emails with Albato to streamline customer communication and boost efficiency across all channels.

Salesforce Slack Integration: what is it and how to use it, benefits of these products and tips
Slack
5 min. read

Salesforce Slack Integration: what is it and how to use it, benefits of these products and tips

Salesforce Slack Integration: what is it and what does it do. Why to use the Salesforce Slack Integration: its main benefits. How to connect Salesforce and Slack: the ultimate guide.

Salesforce Integrations: How to сonnect Salesforce & integrate with 800+ Apps
CRM
1 min. read

Salesforce Integrations: How to сonnect Salesforce & integrate with 800+ Apps

Step-by-step guide to connect and integrate Salesforce with Albato. Learn how to set up powerful Salesforce integrations with 800+ apps to automate your business processes.

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato
7 min. read

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato

With this setup, not only can you transfer your contact database from Quickbase to Google Contacts in bulk, but you can also keep those records updated in real time.

We’re Celebrating a Big Win!
2 min. read

We’re Celebrating a Big Win!

Explore what’s new in Albato: features, apps, and improvements

How to Automate Blog Creation from Google Sheets Using OpenAI
8 min. read

How to Automate Blog Creation from Google Sheets Using OpenAI

With this Solution, every new row in a designated Google Sheet triggers a series of actions to create SEO-friendly blog content, generate images, and notify your team—without writing a single line of code.

Best Workflow Management Software for Teams 2025
11 min. read

Best Workflow Management Software for Teams 2025

In this article, you will learn the top workflow management tools to boost team efficiency. Compare features, pricing, and find the perfect fit for your team.

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters
5 min. read

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters

This article breaks down why missed follow-ups happen so often, how CRM SMS integration solves the root of the problem, and what steps you can take to put your follow-up process on autopilot without losing the human touch.