Create a Travel Approvals Dashboard
Create a Dashboard
You can take your analysis to the next level by placing your reports on a Salesforce dashboard for quick and easy viewing. A dashboard provides an interactive visual display of key metrics and trends. Multiple dashboard components can be shown together on a single dashboard layout, creating rich visual displays of multiple reports that have a common theme.
- Click the Dashboards tab.
- Click New Dashboard.
- Enter the following values.
Travel Requests Dashboard
- Click Create. You can now add reports to your dashboard and move them on to different sections of the dashboard. You can also stretch the components across the grid to have the exact layout of components you need for your dashboard.
- Click + Component.
- Click the Travel Request by Department report and click Select. You are presented with options to configure this component for the dashboard.
- Make sure the Y-Axis is set to Department and the X-Axis is set to Record Count.
- Click Add.
- Click + Component to add our other report.
- Select the Travel Requests by Month report and click Select.
- Let’s make this a vertical, stacked bar chart that sorts data from oldest to newest by adjusting the following: [2x2 table]
- Display As | Stacked Vertical Bar Chart
- Sort By | Trip End Date
- Click Add.
- Drag the chart on the bottom, and position it to the right of the first chart we added. Notice that you have a very flexible grid structure. Play around with stretching your dashboard components to various shapes on the grid.
- Click Save and then the Done. Your dashboard will look like the following.
For real-world scenarios, you can add other reports to the dashboard and show data and key performance indicators (KPIs) from multiple objects from your database.
Congrats on completing the Travel App! You now have a single source of truth that can help control costs and limit unwarranted travel.
- Each employee must submit an electronic request in the system for future travel.
- Each request includes a list of estimated expenses for airfare, hotel, rental car, and so on.
- Each request must be approved by the employee’s manager, and all out-of-state travel must be approved by a travel coordinator.
- Managers have reports and a dashboard to track key travel request trends and KPIs.