Examkin

Question

Difficulty: MediumReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a university alumni association is building a report on donor accounts. The executive team requires the report to group opportunity amounts into custom giving ranges (such as Low, Medium, and High) without modifying the object schema, and to display only accounts that currently have no associated tasks. Which TWO actions should the administrator take to fulfill these business requirements? (Select two.)

  1. Add a Bucket Field based on the Opportunity Amount field to define custom giving range categories.Answer
  2. Add a Cross Filter specifying Accounts without Tasks to isolate accounts lacking follow-up activities.Answer
  3. C
    Create a Summary Formula field on the report to group individual opportunity amount records into giving categories.
  4. D
    Create a roll-up summary field on the Account object to filter out accounts with related activity tasks.
  5. E
    Configure dynamic dashboard running user permissions to dynamically suppress records with open tasks.

Answer

The administrator should create a Bucket Field on the Opportunity Amount field to define custom giving ranges, and apply a Cross Filter set to Accounts without Tasks.
Bucket fields allow report creators to group numeric values such as Opportunity Amount into custom ranges directly within the report builder without modifying the underlying object schema. Additionally, Cross Filters provide the ability to include or exclude parent records based on whether they have or do not have related child records, fulfilling the requirement to filter for Accounts without Tasks.

Step-by-Step Solution

1
Identify the requirement for custom record grouping without schema changes.
Recognize that creating a Bucket Field directly in the report builder allows categorizing Opportunity Amount values into discrete ranges (e.g., Low, Medium, High) without administrator custom fields.
Bucket fields categorize records dynamically within report results without schema overhead.
2
Identify the requirement to evaluate related child record existence (Tasks on Accounts).
Apply a Cross Filter on the report using the relationship condition 'Accounts without Tasks'.
Cross filters filter primary object records based on the presence or absence of related child object records.

Key Concept

Report Filtering, Filter Logic, and Bucketing
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic