Question:

How to Create a Dynamic Dashboard and Grant Visibility to an End-User?

Answer:

Dashboards are visual implementation snapshots that are generated from the data in associated reports and are presented as graphical elements.  These graphical elements are known as dashboard components, of which there are these five types:

• charts
• gauges
• tables
• metrics
• Visualforce pages

A dynamic dashboard runs using the security settings of the user viewing the dashboard.  Each user sees the dashboard according to his or her own access level.  This approach helps to share one common set of dashboard components to users with different levels of access.  A single dynamic dashboard can display a standard set of metrics across all levels of your organization.

Before creating Dynamic Dashboards, pre-prepared source reports containing the data desired to display need to be created.  Folders that are accessible to all dashboard viewers, in which dynamic dashboards and corresponding component source reports should also be created.

To create a Dynamic Dashboard follow the steps below:

1. Click on the Reports tab.  
2. Click on the New Dashboards... button, as shown in the following screenshot:

3. Click on the drop-down arrow button to the right of the View dashboard as field option.
4. Select Run as logged-in user option.
5. Click on OK.
6. Click on Save on the main dashboard.
7. Navigate to: Setup --> App Setup --> Customize --> Home --> Home Page Layouts.
8. Click Edit next to the appropriate Home Page Layout that applies to the end-user profile that has visibility to this dashboard.
9. Ensure Dashboard Snapshot is checked.
10. Log in as the end-user.
11. On the Home page, click Customize Page on the Dashboard Component, as seen in the following screenshot:

12. Under the column Show Data From type in the name of the Dashboard.
13. Click Save.

Related Documentation:

Salesforce.com Documentation: Setup Dynamic Dashboards