Explore Reports and Dashboards
- Get more information from interactive charts without needing to drill into reports (the charts look fabulous, too!)
- Create dashboards with more than three columns and column-spanning components using the Lightning dashboard editor
- Without launching the report builder, you can edit report filters, show or hide a chart, totals, and details
- Find, manage, and create reports and dashboards more easily via redesigned home pages
- Work with your reports and dashboards from Salesforce Classic in Lightning Experience
Access your reports from the Reports tab, and your dashboards from the Dashboards tab (1).
You can build a new report or dashboard (2) right from this page by clicking New Report or New Dashboard. Create a folder by clicking New Folder. Customize the tab layout by clicking the gear icon and then clicking Select Fields to Display.
Click a column heading (3) to sort by name, folder, creator, or whoever last modified a report or dashboard. Click again to reverse the sort order. Resize columns by hovering over the border area and dragging the border. Choose whether text in a column clips or wraps from the column actions menu.
The more actions menu provides click access to whatever you want to do (4). It’s the fastest way to edit, subscribe, or favorite. But, if all you want to do is view a report or dashboard, it’s a little quicker to click the name instead!
Find a report or dashboard using filtered lists and folders (5). Filtered lists are the fastest way to find the report or dashboard you’re looking for. For example, you can quickly find the Open Deals report you were reading last Friday in Recent. Folders let you group related reports or dashboards, so they’re easy to find again later.
Get started from the toolbar (1). From here, you can add components and filters, undo or redo edits, edit chart properties, and perform administrative tasks like saving. Unique to Lightning Experience, from the chart properties menu, you can customize chart colors and dashboard theme (background color).
To edit an already-placed dashboard component, click (2). You can choose a data-supplying source report, change chart types, edit the component title, and more. To remove a component, click X.
Arrange dashboard components more easily than ever by dragging them anywhere on the grid (3). Lightning Experience dashboards now feature more than three columns. They feature up to nine columns and unlimited rows. Dashboard components can span as many columns and rows as you like. Drag the corners and sides of a dashboard component to make it bigger or smaller. Charts, tables, and metrics all dynamically resize. Go ahead and get creative with your dashboard layout!
Put a better table in your dashboards . The Lightning table is a new dashboard component that’s only available in Lightning Experience. How much better is it? Here’s what it offers.
- Up to 10 columns and 200 rows!
- Columns come from source reports’ report type. That means that you don’t have to add a field to the source report to show it in the table.
- Show Chatter photos and conditional highlighting.
- Lightning tables are dashboard filter compatible.
- Customize dashboard color palette and theme.
Lightning tables don’t appear when you view the dashboard in Salesforce Classic.
View dashboards as other people (1). If properties are set to allow you to choose whom you view the dashboard as, click Change to see the dashboard as someone else.
Refresh, edit, and collaborate (2). Perform common tasks, like refreshing dashboard data, from the toolbar.
View source reports (3). To view a component’s source report, click View Report. When it opens, dashboard filters get applied to the source report.
Hover over charts to see more details (4). Click a chart segment or datapoint to open a filtered source report.
Expand dashboard components to see a larger version of it (5). If a chart is a little too small to make out an important detail, expand it.
- — Show or hide a report chart.
- — Add, remove, or change report filters. After applying a filter, the report automatically refreshes to show filtered data. You no longer have to open the report builder to filter a report.
- — Open the report feed to collaborate with others on report data.
- — Refresh your report to show the latest data.
- — Show or hide details like subtotals, grand totals, and record counts from your report.
You can view key metrics at the top of every report (2). Report headers float on both the X and Y axes (3), so you always know what field you’re reviewing without needing to scroll. And, we’ve redesigned the report format so that groupings are easier to read (4).
You can add, remove, and edit report filters (5) right from the report’s page. You no longer have to open the report builder to filter the report you’re reading. If you want to see your sales pipeline for the apparel industry, edit the Industry filter accordingly and your report refreshes.
You can also lock filters (6). If you want to share a report about your late-stage sales pipeline and don’t want to share early-stage data, lock the Stage filter. Locked filters can’t be edited on the report run page. You lock and unlock filters in the report builder.
You’re probably wondering: “But can I customize the chart?” Yes, you can (7)! Change the chart type, title, and more from the chart options menu ().
- You can view and edit both in Lightning Experience.
- After saving a Salesforce Classic dashboard in Lightning Experience, you can’t edit it in Salesforce Classic. Instead of editing a Salesforce Classic dashboard in Lightning Experience, consider cloning the dashboard and editing the clone. That way, you can still edit the original dashboard in Salesforce Classic.
- You can view and open folders that you created in Salesforce Classic in Lightning Experience. Lightning Experience obeys sharing rules set on report and dashboard folders in Salesforce Classic.
- Joined reports are available as a beta in Lightning Experience.
- You can view and edit reports created in Lightning Experience in Salesforce Classic.
- You can’t edit dashboards created in Lightning Experience in Salesforce Classic, but you can view them. Lightning tables, a table component only available in Lightning Experience, don’t appear when you view a dashboard in Salesforce Classic.
- Dashboards that you create in Lightning Experience that have more than three columns automatically display in Salesforce Classic with three columns (retaining all dashboard components).
For more information about Lightning Experience reports and dashboards differences, see Reports and Dashboards: What’s Different or Not Available in Lightning Experience in help.