Content Templates

Salesforce Lightning Using Reports Template

Step-by-step instructions for creating, editing, and deleting reports in Salesforce Lightning, with filters, report names, folders, and best practices.

1. How to Create a Report in Salesforce Lightning

Salesforce Lightning Sales home page, the starting point for opening the Reports tab to create a report
  1. Click the Reports tab.
  2. Click New Report.
Salesforce Lightning Reports tab with the New Report button highlighted for starting a new report
  1. Choose Report Type.
  2. Search for “Report Types” to learn more.
  3. Click Continue.
Salesforce Lightning Choose Report Type window for selecting a report type and clicking Continue
  1. Outline Tab
  • Groups
  • Groupings of up to 3 fields if no Group Columns; otherwise max of 2 Group Rows and 2 Group Columns.
  • Use the search bar to find fields by name.
  • Group Rows
  • Add fields as groups to create a summary report.
  • Group Columns
  • Add Column groupings to create a matrix report.
  • Columns
  • Drag and drop to rearrange fields.
  • Click the X to remove a field.
  • Use the search bar to find fields by name.
Salesforce Lightning report builder with Groups and Columns set up before clicking Save & Run
  1. Filter Tab
  2. Search 🔍 for “Report Filters” to learn more about enhancing reporting capabilities.
  3. Click Save & Run.
  4. Enter a Report Name.
  5. Click Select Folder and choose what folder the report should be saved to.
  6. Click Save.
Salesforce Lightning Save Report dialog for naming the report and choosing a folder to save it to

11. Toggles

  • Row Counts
  • Subtotals
  • Grand Total
Salesforce Lightning report view with Row Counts, Subtotals and Grand Total toggles turned on
  • Detail Rows
Salesforce Lightning report with the Detail Rows toggle turned off, showing only grouped summary rows

‍

2. How to Delete a Report in Salesforce Lightning

Reminder that this deletes the report for all users and not just you.

Salesforce Lightning Sales home page with the Reports tab being clicked to open the reports list

1. Click the Reports tab.

2. Find the Report you want to delete.

3. Click the Down Arrow.

4. Click Delete.

Salesforce Lightning Reports list with the row dropdown open and Delete highlighted for deleting a report

-OR-

1. Navigate to the Report.

2. Click the Down Arrow.

3. Click Delete.

Salesforce Lightning report view with the Edit button highlighted for editing the report

3. How to Edit a Report in Salesforce Lightning

1. Navigate to the Report you want to edit.

2. Click Edit.

Salesforce Lightning report view with the Edit button highlighted for editing the report

3. Make the needed edits.

  • Outline Tab
  • Groups
  • Groupings of up to 3 fields if no Group Columns; otherwise max of 2 Group Rows and 2 Group Columns.
  • Use the search bar to find fields by name.
  • Group Rows
  • Add fields as groups to create a summary report.
  • Group Columns
  • Add Column groupings to create a matrix report.
  • Columns
  • Drag and drop to rearrange fields.
  • Click the X to remove a field.
  • Use the search bar to find fields by name.
Salesforce Lightning report builder with Groups and Columns set up before clicking Save & Run
  • Filter Tab
  • Search 🔍 for “Report Filters” to learn more about enhancing reporting capabilities.

4. You have 2 options:

  • Save – Overwrite the existing report with the changes you made.
  • Click Save.
  • Save As – Keep the existing report as is and create a report with these edits as new.
  • Click the Down Arrow next to Save.
  • Click Save As.
Salesforce Lightning report editor with the Save dropdown open to Save As, for saving edits as a new report

5. Enter a Report Name.

6. Click Select Folder and choose what folder the report should be saved to.

7. Click Save.

Salesforce Lightning Save Report dialog for naming the report and choosing a folder to save it to

8. Toggles

  • Row Counts
  • Subtotals
  • Grand Total
Salesforce Lightning report view with Row Counts, Subtotals and Grand Total toggles turned on
Salesforce Lightning report with the Detail Rows toggle turned off, showing only grouped summary rows

4. Report Best Practices in Salesforce Lightning

  • Search: Before creating a new report, search first!
  • Use Filters:
  • Prevent Missing Results: Set Standard Filters to “All Records” for “All Time”
  • Reuse Reports: Use relative date filters
  • Cross-Filters: Use this instead of creating various Report Types
  • Naming conventions: Make it easy to find your report again by keeping your report naming simple
  • Organization: Save reports to the appropriate folder
  • Auto-calculate: Utilize Groupings to enable Sum, Average, Max, Min of numbers/currency
  • Pro Tip ✅ : If you need a new report but there are only a minor changes from an existing one, make the edits and then click Save As to save it as a new report!

5. Report Chart Types in Salesforce Lightning

When creating or editing a Chart you have 8 chart options to choose from.

Salesforce Lightning Display As menu listing report chart types such as Bar, Column, Donut and Funnel

1. Bar

  • You need at least one Grouping on the Report.
Salesforce Lightning Bar chart type option for report charts

2. Column

  • You need at least one Grouping on the Report.
Salesforce Lightning Column chart type option for report charts

3. Stacked Bar

  • You need at least two Groupings on the Report.
  • Choose to stack to 100% instead of by value.
Salesforce Lightning Stacked Bar chart type option for report charts

4. Stacked Column

  • You need at least two Groupings on the Report.
  • Choose to stack to 100% instead of by value.
Salesforce Lightning Stacked Column chart type option for report charts

5. Line

  • Display data over time.
  • Display cumulative totals.
Salesforce Lightning Line chart type option for report charts

6. Donut

  • A pie chart with a hole in the center for the value total of all wedges.
  • Display value and/or percent.
  • Combine Small Groups of wedges into an “Other” wedge.
Salesforce Lightning Donut chart type option for report charts

7. Funnel

  • Use to group a linear process like Opportunity Stage.
  • Display value and/or percent.
  • Combine Small Groups into an “Other” part of the Funnel.
Salesforce Lightning Funnel chart type option for report charts

8. Scatter Plot

  • One or two Groupings and their measured values.
Salesforce Lightning Scatter Plot chart type option for report charts

6. Report Charts in Salesforce Lightning

Charts can be added to reports to see a summary of results at a glance:

Salesforce Lightning report showing a donut chart above grouped rows, a summary of results at a glance

1. Navigate to a Report.

2. Click Edit.

Salesforce Lightning report view with the Edit button highlighted, the step to start adding a chart

3. Click Add Chart.

Salesforce Lightning report editor with the Add Chart button highlighted, for adding a chart to a report

4. Click Chart Properties.

5. Choose a Chart Type.

  • Search 🔍 for “Report Chart Types” to learn more.

6. Configure the Chart.

  • These options will change depending on the Chart Type you choose.
  • Making configuration changes will update the Preview in real-time.
  • Click Remove Chart to do just that.

7. Click Chart Properties to close out of the configurator.

Salesforce Lightning report chart settings for choosing a chart type, setting chart attributes, or removing the chart

7. Report Filters in Salesforce Lightning

You can add filters to a Report to see records that match certain criteria instead of all records for that Object.

1. Navigate to a Report.

2. Click Edit.

Salesforce Lightning report view with the Edit button highlighted, the step to start adding a chart

3. Click the Filters tab.

4. Toggle on Update Preview Automatically to see the changes you are making apply to the report in real time.

5. Update Standard Filters.

5a. Show Me

  • My records
  • Will show the records where you are the listed Record Owner.
  • My team’s records
  • Will show the records where you are the Role above the Record Owners.
  • Dependent on the Salesforce Role Hierarchy.
  • All records
  • Will show all records.

5b. Date Filter

  • Date
  • Choose the date field to filter by.
  • Range
  • All Time
  • Custom
  • Dynamic, out-of-the-box range.

6. Add Custom Filters.

6a. Select the Field.
6b. Select the Operator.
6c. Enter the Value.
6d. Click Apply.

7. Click Save & Run.

Salesforce Lightning report Filters panel for adding a custom field filter with an operator and value, then saving

Add Filter Logic

Filter Logic allows you to be more specific in drilling down your results.

1. Click the Down Arrow next to “Filters”

2. Click Add Filter Logic.

Salesforce Lightning report Filters menu with Add Filter Logic highlighted, for refining filter results

3. By default, Filter Logic is only ANDs, meaning all filters need to be true for the record to appear.

4. You can change it to be 1 OR 2 so that if either result is true for the record it will appear.

5. If you have even more filters you can add more detailed logic including parenthesis.

  • i.e. (1 OR 2) AND 3

6. Click Apply.

Salesforce Lightning Edit Filter Logic dialog for combining report filters with AND and OR logic

8. Report Folders in Salesforce Lightning

Report Folders allow you to organize your Reports into different categories.

The Reports tab defaults to the Recent Reports list.

You can search 🔍 for existing Reports using the search bar at the top

  • Searching for reports will help save time since you won’t need to create one from scratch
  • Search for a keyword to narrow your results
  • For example, “industry” if you are looking for Accounts by Industry
Salesforce Lightning Reports tab with report folders, side navigation and the search bar for finding existing reports

9. Report Properties in Salesforce Lightning

To change underlying Report Settings:

1. Navigate to a Report.

2. Click Edit.

Salesforce Lightning report view with the Edit button highlighted, the step to start adding a chart

3. Click the Down Arrow next to Save.

4. Click Properties.

Salesforce Lightning report editor Save dropdown with Properties highlighted, for changing report settings

5. Make edits:

  • Name
  • Description
  • Folder

6. Click Save.

Salesforce Lightning Save Report dialog for editing a report's name, description and folder

10. Report Types in Salesforce Lightning

The Report Type you choose controls what fields you can add and filter with on your report

Report Type names are made up of Object names

  • Search 🔍 for “Objects” to learn more

Finding a Report Type:

  • Choose a category on the left
  • Search 🔍 for the name in the search bar
  • Scroll down
Salesforce Lightning Choose Report Type dialog for finding a report type by category or search

Report Types can be made up of 1 or more Objects. If made up of 2 or more objects they can have varying relationships such as

  • Object with at least one related Object
  • i.e. Accounts with Contacts
  • The report will only return records that fit the filter criteria for Accounts that have at least 1 Contact record.
Venn diagram of Account and Contact overlapping, showing a report that returns only Accounts with at least one Contact
  • Object with or without a related Object
  • i.e. Accounts with or without Contacts
  • The report will return records that fit the filter criteria for all Accounts, whether they have related Contacts or not.
Venn diagram showing a report that returns all Accounts, whether or not they have related Contacts

11. Reports in Salesforce Lightning

Reports are collections of records to gain analytical details

  • Help you slice and dice the data in different ways to compare in just a handful of clicks and drag-and-drops
  • See trends over time
  • Quickly see counts, averages, subtotals, totals, and more

Report Examples:

  • Cases Opened Each Month
  • Minimum, Maximum, and Average Time to Close a Case
  • In Minutes, Hours, Days
  • Opportunity Win Rate
  • Opportunity Forecast
  • Accounts Per Rep
  • Calls Made Per Rep Per Account

‍