Content Templates

Salesforce Lightning Dashboards

Customize this Salesforce Lightning training to give your revenue team the help they need as they're creating dashboards, reporting, and more.

1. Dashboard Component Types in Salesforce Lightning

When creating or editing a Component in Salesforce Lightning, you have 11 chart options to choose from:

Salesforce Lightning Add Component dialog with the Display As options for choosing a dashboard chart type

1. Horizontal Bar Chart

  • You need at least one Grouping on the Report.
Horizontal bar chart component type in Salesforce Lightning dashboards

2. Vertical Bar Chart

  • You need at least one Grouping on the Report.
Vertical bar chart component type in Salesforce Lightning dashboards

3. Stacked Horizontal Bar Chart

  • You need at least two Groupings on the Report.
  • Choose to stack to 100% instead of by value.
Stacked horizontal bar chart component type in Salesforce Lightning dashboards

4. Stacked Vertical Bar Chart

  • You need at least two Groupings on the Report.
  • Choose to stack to 100% instead of by value.
Stacked vertical bar chart component type in Salesforce Lightning dashboards

5. Line Chart

  • Display data over time.
  • Display cumulative totals
Line chart component type in Salesforce Lightning dashboards

6. Donut Chart

  • 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.
Donut chart component type in Salesforce Lightning dashboards

7. Metric Chart

  • Display a single number/currency.
  • Configure a range where the color of the value changes when the value does.
Metric chart component type in Salesforce Lightning dashboards

8. Gauge Chart

  • Standard
    • Configure a range where the color of the value changes when the value does.
    • Visually displays the range and colors of the value.
    • Display value and/or percent.
  • Dynamic
    • Extra functionality allows you to choose the goal that the metric is compared to based on a field value to allow it to be dynamic.
Gauge chart component type in Salesforce Lightning dashboards

9. Funnel Chart

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

10. Scatter Chart

  • One or two Groupings and their measured values.
Scatter chart component type in Salesforce Lightning dashboards

11. Lightning Table

  • Mimics a Grouped report with Detail Rows toggled off.
  • Add Conditional Highlighting.
Lightning Table component type in Salesforce Lightning dashboards

2. Dashboard Components in Salesforce Lightning

Each chart on a Dashboard is called a Dashboard Component. They are visual representations of existing reports and can be dragged and dropped to display different data in various sizes and orders.

1. Navigate to a dashboard.

2. Click Edit.

Salesforce dashboard view with the Edit button highlighted, for the step of navigating to a dashboard and clicking Edit

3. Click + Component.

Salesforce dashboard in edit mode with the + Component button highlighted, for the step of adding a component

4. Select a Report.

5. Click Select.

Salesforce Select Report dialog for the steps of choosing a report and clicking Select

4. Click Delete.

6. Choose a Component Type.

  • Search 🔍 for “Dashboard Component Types” to learn more.

7. Configure the Component display.

  • These options will change depending on the Component Type you choose.
  • Making configuration changes will update the Preview in real-time
  • Sort by
    • Ascending = Up arrow
    • Descending = Down arrow

8. Click Add.

Salesforce Add Component dialog for configuring the component display and previewing it before clicking Add

Edit Components

1. Navigate to a Dashboard.

2. Click Edit.

3. Click the Funnel icon to set what field is used to filter that component for the Dashboard Filters.

4. Click the ✏️ icon to Edit the Component.

5. Click the ❌ icon to Delete the Filter.

Salesforce dashboard component with filter, edit and delete icons highlighted, for editing a component

3. Dashboard Filters in Salesforce Lightning

There may be certain fields where data needs to be seen across the board and also per field value

Examples:

  • Case Priority
  • Account Region
  • Opportunity Owner
Salesforce dashboard with the Close Date filter dropdown open, showing how Dashboard Filters change the view

Benefits

With Dashboard Filters, you create one dashboard and one set of source reports and add a dashboard filter to see the various changes at the click of a button.

  • 1 set of source reports, 1 dashboard, and 1 Dashboard Filter with options of Global, Americas, APAC, EMEA
  • VS
  • 4 sets of source reports and 4 dashboards – one each for Global, Americas, APAC, EMEA

Allotment

Add up to 3 filters per Dashboard.

Examples:

  • By Owner
    • View total pipeline vs pipeline per Owner
  • By Field Value
    • Opportunity Type is New Business, Expansion, Renewal
    • Country/Region
    • Industry
    • Product Interest
  • Relative Dates
    • Close Date is Next Month, Next Quarter, Next Year
  • Number/Currency Ranges

Create a Filter

1. Navigate to a dashboard.

2. Click Edit.

Salesforce dashboard view with the Edit button highlighted, for the step of navigating to a dashboard and clicking Edit

3. Click ➕ Filter

Salesforce Lightning dashboard in edit mode with the Filter button highlighted for adding a filter

4. Select a Field.

  • Optionally, change the Display Name.

5. Click Add Filter Value.

Salesforce Add Filter dialog for selecting a field and display name, then adding a filter value

6. Select the Operator.

7. Choose the Values.

  • Select individual values or combine them.
  • Value options change depending on the field type.
  • Optionally, change the Display Text.

8. Click Apply.

Salesforce filter value dialog for choosing an operator and relative date values, then applying

9. Click Add.

Salesforce Add Filter dialog with several filter values chosen and the Add button highlighted

10. Click Save

Salesforce Lightning dashboard in edit mode with the new filter in place and the Save button highlighted

Edit a Filter

1. Navigate to a Dashboard.

2. Click Edit.

3. Click the ✏️ icon to Edit the Filter.

4. Click the 🗑 icon to Delete the Filter.

Salesforce Lightning dashboard in edit mode with the edit and delete icons highlighted on an existing filter

4. Dashboard Folders in Salesforce Lightning

Dashboard Folders allow you to organize your Dashboards into different categories.

When you click the Dashboard tab it defaults to the Recent Dashboards list

  • You can search for existing Dashboards using the search bar at top
  • Searching for Dashboards will help save time since you won’t need to create one from scratch
  • Search for a keyword to narrow your results
  • For example, “Cases” if you are looking for a Dashboard that references Cases.
Salesforce Dashboards tab with the folder list and search box for finding and organizing dashboards

5. Dashboard Properties in Salesforce Lightning

Change underlying Dashboard Settings:

  • Name
  • Folder
  • Light or dark mode
  • Color palette of chart colors

1. Navigate to a Dashboard.

2. Click Edit.

Salesforce dashboard view with the Edit button highlighted, for the step of navigating to a dashboard and clicking Edit

3. Click Edit Dashboard Properties.

Salesforce Lightning dashboard in edit mode with the properties gear icon highlighted

4. Make edits:

  • Name
  • Description
  • Folder
  • View Dashboard As
    • Me
    • Another Person
    • The dashboard viewers
    • Let the user choose
  • Dashboard Grid Size
    • 12 columns
    • 9 columns
  • Dashboard Theme
    • Light
    • Dark
  • Dashboard Pallette
    • Change the colors of the chart

5. Click Save.

Salesforce Dashboard Properties dialog for editing name, folder, grid size, theme and palette, then saving

6. Dashboards in Salesforce Lightning

Dashboards are collections of report charts to give a visual picture of a certain topic. Dashboards usually display similar information with different criteria.

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

For instance:

Dashboards for Opportunities might include:

  • Pipeline to Close in the Next 90 Days
  • Renewals Remaining to Close This Quarter
  • New Logos Won This Year
  • New Business ARR This Year Compared to Goal
  • Expansion ARR This Year Compared to Goal
  • Churn This Year Compared to Goal

Dashboards for Cases might include:

  • Cases Opened by Month
  • Cases Closed by Month
  • Cases in Queue
  • Cases by Stage
  • Average Time to Close by Case Priority
  • Cases Per Rep
Salesforce Lightning dashboard made of report charts, including pipeline, closed deals and closed business

7. How to Create a Dashboard in Salesforce Lightning

Salesforce Lightning home view for the step of clicking the Dashboards tab

1. Click the Dashboards tab

2. Click New Dashboard

Salesforce Dashboards tab with the New Dashboard button for starting a new dashboard

3. Enter the Dashboard Name.

4. Choose to save it to a different, public folder.

5. Click Create.

Salesforce New Dashboard dialog for naming the dashboard, choosing a folder and clicking Create

6. You’ve created the shell, now, make it actionable by searching 🔍 for the following keywords to learn more:

  • Dashboard Components
  • Dashboard Filters

8. Refreshing a Dashboard in Salesforce Lightning

Dashboards are not automatically refreshed each time they are opened, so be sure to review the date it was last refreshed to ensure you are looking at up-to-date metrics.

1. Navigate to a Dashboard

2. See that there is a warning of “Last refreshed X days ago. Refresh this dashboard to see the latest data.”

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

3. Click Refresh

Salesforce dashboard showing a last-refreshed warning and the Refresh button for updating its data

4. See the Dashboard data update and the warning disappear.

Salesforce dashboard after refresh, with the warning gone and the updated as-of time shown