Create Reports and Dashboards

What You’ll Do

• Create a Report for Supply costs.
• Create a Dashboard to display reports.

Create a Report

Bosses love reports. It's a fact. A report in Salesforce is a list of records that meet the criteria you define. It’s displayed in Salesforce in rows and columns, and can be filtered, grouped, or displayed in a graphical chart. You'll create a report to monitor your supply costs for each Battle Station being constructed.

1. Click the App Launcher  and select Battle Station Construction
2. Click the Reports tab and click the New Report... button.
3. Expand the Other Reports folder, select Battle Station with Supplies and click Continue. If you don't see the Battle Station with Supplies report type, go to Setup and click Object Manager. Next to Supply click the drop-down, then click Edit. Under Optional Features, check Allow Reports. Click Save. Then go back and create the report.
4. Search for Quantity, Unit Cost, and Total Cost fields in the Add column search and add them as columns one at a time.  Note: You can also drag the fields from the Fields pane, in the Battle Station with Supplies: Info folder in to Columns section.
5. In the Add group search, enter Battle Station Name and select Battle Station Name. This will separate the report by individual Battle Station records. 
6. Click the Update Preview Automatically toggle to view column menus.
7. Open the menu on the Quantity, Unit Cost columns and select Summarize, then deselect Sum. Leave Sum as selected for Total Cost Column. 
8. Click Save & Run, enter Supplies for the Report Name and click Save.

You should see something like the following with subtotals for each Battle Station. Your boss will love you and certainly give you the rest of the day off. Perhaps even buy you a drink in the Cantina?

Create a Dashboard

You can "WOW" the big boss even more by adding a number of reports to a dashboard for quick and easy viewing. Bosses love eye-candy! A dashboard is a visual display of key metrics and trends. The relationship between a dashboard component and report is 1:1; for each dashboard component, there is a single underlying report. Multiple dashboard components can be shown together on a single dashboard page layout, creating a powerful visual display and a way to consume multiple reports that often have a common theme, like number of exhaust ports unsecured, toilet paper usage per Battle Station, etc.

1. Click the Dashboards tab.
2. Click New Dashboard... button.
3. Name the dashboard as Construction and click on Create.
4. Click the +Component button on the top of the page and select the Supplies report.
5. Select the Vertical Bar Chart component and click Add. 
6. Click the Save button and then Done.

Resources

• Trailhead: Lightning Experience Reports & Dashboards
• Trailhead: Getting Started with Salesforce Reports and Dashboards