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 Icon displaying a grid of nine dots. This icon is used to bring up the App Launcher. and select Battle Station Construction
  2. Click the Reports tab and click the New Report... button.
  3. Click 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. The Preview section highlighting that the Summary format should be selected as the format. 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. Report Builder showing what the report looks like after dragging the Battle Station: Battle Station Name field from the Fields list onto the preview section.
  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. Report builder showing the Summarize This Field function, allowing you to summarize by a given field.
  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?

Preview of what the Battle Station with Supplies report will look like when the user clicks Run Report. Red arrows highlight the Subtotals displayed in the report.

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 AddThe Add Component page is displayed when a new dashboard is created. This page allows you to select the report to display and then previews the result.
  6. Click the Save button and then Done.

Showing the chart that is displayed in the Construction dashboard. This is displayed after the user clicks Done.


Keep learning for
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities