Question

Difficulty: HardDashboard Design, Components, and Dynamic Filters

A Salesforce Administrator at an international medical equipment manufacturing company is designing an Executive Maintenance & Sales Dashboard in Lightning Experience. The dashboard aggregates data from three source report types: 'Accounts with Assets', 'Assets with Maintenance Contracts', and 'Contracts with Billing Schedules'. The administrator configures a dynamic dashboard filter based on the 'Account Region' picklist field. During configuration, the administrator notices that components fed by 'Contracts with Billing Schedules' cannot be filtered by 'Account Region'. Which configuration state explains why the dashboard filter cannot be applied to these components?

  1. The source report type for 'Contracts with Billing Schedules' does not include the Account Region field or any compatible field in its available columns.Answer
  2. B
    The dashboard running user security settings restrict field-level visibility on the Account Region field for end users viewing the contract records.
  3. C
    The source report utilizes a summary formula instead of a row-level formula to evaluate regional groupings across contract records.
  4. D
    Dynamic Forms component visibility rules on the Contract record page layout have hidden the Account Region field from the active profile.

Answer

The source report type for 'Contracts with Billing Schedules' does not include the Account Region field or any compatible field in its available columns.
For a dynamic dashboard filter to apply to a component, the source report used by that component must include a field that is compatible with the filter field type. If the underlying report type ('Contracts with Billing Schedules') does not contain the 'Account Region' field or an equivalent field in its layout, the administrator cannot map the dashboard filter to that component.

Step-by-Step Solution

1
Analyze why a dynamic dashboard filter cannot be mapped to a specific component's source report.
Dashboard filters require each component's source report to contain the filter field (or an equivalent field with a matching data type) within its report type schema.
Salesforce dynamic dashboard filters map directly to fields available in the underlying source report.
2
Evaluate the report type structure for 'Contracts with Billing Schedules'.
If the custom report type relationship omits the Account object or does not expose 'Account Region', the field cannot be selected for filter mapping.
Filter mapping relies on schema field availability in the source report type.
3
Select the option describing the field availability constraint in the source report type.
The correct condition is that the source report type lacks the Account Region field or compatible equivalent.
Adding the field to the custom report type layout is required to resolve this dashboard filter mapping issue.

Key Concept

Dashboard Filter Field Mapping Prerequisites
Rate this question