1. Dashboard Component Types in Salesforce Lightning
When creating or editing a Component in Salesforce Lightning, you have 11 chart options to choose from:
1. Horizontal Bar Chart
- You need at least one Grouping on the Report.
2. Vertical Bar Chart
- You need at least one Grouping on the Report.
3. Stacked Horizontal Bar Chart
- You need at least two Groupings on the Report.
- Choose to stack to 100% instead of by value.
4. Stacked Vertical Bar Chart
- You need at least two Groupings on the Report.
- Choose to stack to 100% instead of by value.
5. Line Chart
- Display data over time.
- Display cumulative totals
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.
7. Metric Chart
- Display a single number/currency.
- Configure a range where the color of the value changes when the value does.
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.
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.
10. Scatter Chart
- One or two Groupings and their measured values.
11. Lightning Table
- Mimics a Grouped report with Detail Rows toggled off.
- Add Conditional Highlighting.
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.
3. Click + Component.
4. Select a Report.
5. Click 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.
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.
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
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.
3. Click ➕ Filter
4. Select a Field.
- Optionally, change the Display Name.
5. Click Add 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.
9. Click Add.
10. Click Save
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.
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.
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.
3. Click Edit Dashboard Properties.
4. Make edits:
- Name
- Description
- Folder
- View Dashboard As
- Me
- Another Person
- The dashboard viewers
- Let the user choose
- Dashboard Grid Size
- Dashboard Theme
- Dashboard Pallette
- Change the colors of the chart
5. Click Save.
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.
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
7. How to Create a Dashboard in Salesforce Lightning
1. Click the Dashboards tab
2. Click New Dashboard
3. Enter the Dashboard Name.
4. Choose to save it to a different, public folder.
5. Click 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
4. See the Dashboard data update and the warning disappear.
