Filter an Embedded Dashboard

Add a Filter to an Embedded Dashboard

If you’re not already looking at an account page, follow these steps.

1. In the navigation bar of the Sales app, click the down arrow on the right of the Accounts tab.
   
2. Click All Accounts.
   
3. In the Account Name column, click any account name, such as Adkins907 Inc.
   

Add the filter to the embedded Opportunity Details dashboard.

1. On the account page, click the Setup icon at the upper right, and then click Edit Page.
   
2. Click anywhere in the Opportunity Details dashboard.
   
3. In the properties list on the right, click Add Dashboard Filter under the Dashboard Filters section to open the dashboard filter builder.
   
4. In the Data Source field, select DTC Opportunity.
   
5. For Data Source Field, select Account Name.
   
6. For Operator, select Equals, and for Object Field select Account Name to set Account > Name.
   

7. To apply the filter, click Ok.
   
8. Click Save in the upper right.
   
9. To return to the account page, click the back arrow in the upper left.
   

Depending on the account you selected, the Opportunity Details dashboard might or might not show any data. The Adkins907 Inc account, for instance, has one open opportunity and one won opportunity.

You can prove that you’re looking at only the opportunities for Adkins907 in the dashboard: Click in the Account filter. You see that the only account listed is Adkins907 Inc.

Let’s look at something a bit more interesting.

1. In the Search Salesforce box at the top of the page, type Aguilar870.
   
2. In the search results, click the entry for the Aguilar870 Inc account.
   

The Opportunity Details dashboard shows two open opportunities. In the Stage section, you can click Lost to see one lost opportunity. (This account has three opportunities in total. You can see all of them by scrolling down to the Opportunities section of the page.)

The sample dataset doesn’t contain many opportunities. In real life, you’d probably see a lot more.

You can select any account page, and the embedded dashboard now filters its data to show only the opportunities associated with that account. A sales rep can quickly see which opportunities are the most promising to pursue. Or the VP of Sales can check the open opportunities for an account and see at a glance how they’re progressing.

Go Beyond CRM Analytics Embedded in Salesforce

Embedding a dashboard in a Lightning Experience page and adding a filter is just the start to making CRM Analytics dashboards and their data insights available everywhere. Consult the resources listed at the end of this project to learn more about advanced embedding and integrating technologies.

Resources

• Add Lightning Components to Any App with Lightning Out
  
• CRM Analytics SDK Developer Guide
  
• CRM Analytics REST API Developer Guide
  
• CRM Analytics SAQL Reference