Overview
When a CRM Analytics dashboard component that contains a Filter is embedded on a Salesforce record page, users may see an "Unexpected Error" message. This error does not originate from the CRM Analytics dashboard itself, but from the underlying Salesforce record page.
Root Cause
The underlying error that triggers this behavior is:
"This record could not be loaded because it includes too many formula fields with complex formulas, or too many custom fields. Ask your Salesforce administrator to remove some formula fields or simplify the formulas in use."
When a record page contains too many formula fields with complex formulas, or too many custom fields, the record page fails to load. This failure causes the embedded CRM Analytics dashboard component — which depends on the record page context to apply the filter — to display an "Unexpected Error".
Users see the "Unexpected Error" on embedded CRM Analytics dashboards that contain a filter when the hosting record page exceeds Salesforce's formula field or custom field limits.
Workaround for the Unexpected Error on Embedded CRM Analytics Dashboards
Because the root cause is Salesforce's record page formula field limit rather than the CRM Analytics dashboard itself, the recommended workaround is to embed the CRM Analytics dashboard using a Visualforce page instead of the native dashboard component on the record page.
When embedding with a Visualforce page, use the correct filtering syntax (not selection syntax) to retrieve the record page context and pass it to the dashboard. This bypasses the formula field limit issue on the record layout and allows the CRM Analytics dashboard with filters to load correctly.
To implement this workaround:
If reducing the number of formula fields or simplifying existing formulas on the record page is feasible, that is a permanent fix and removes the need for the Visualforce workaround.
000381610

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.