Examkin

Soru

Zorluk: OrtaReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a wildlife conservation foundation is creating an Account report for the fundraising team. Management needs the report to meet the following criteria:
1. Include Accounts where Total Gifts is greater than $10,000 OR the Account Region is 'West'.
2. Regardless of total gifts or region, ONLY include Accounts that have at least one related Active Recurring Donation record.
3. Group Accounts into three gift size tiers (Tier 1, Tier 2, and Tier 3) directly within the report interface without modifying the Account object schema.

Which TWO features or configurations should the administrator use to fulfill these requirements?

  1. Add a Cross Filter on Accounts with Recurring Donations to filter for accounts that possess at least one active child recurring donation record.Cevap
  2. Create a Bucket Field on the Total Gifts field to categorize records into Tier 1, Tier 2, and Tier 3 groupings directly in the report.Cevap
  3. C
    Create a Summary Formula field on the report to group the Account total gifts into Tier 1, Tier 2, and Tier 3 ranges.
  4. D
    Use a Row-Level Formula field to filter out Accounts that do not have active recurring donation child records.

Cevap

The administrator should add a Cross Filter on Accounts with Recurring Donations and create a Bucket Field on the Total Gifts field.
To satisfy the requirement of filtering parent Account records based on the existence of child Recurring Donation records, the administrator must use a Cross Filter (Accounts WITH Recurring Donations). To satisfy the requirement of categorizing Accounts into Tier 1, Tier 2, and Tier 3 directly in the report without creating schema fields, the administrator must use a Bucket Field.

Adım Adım Çözüm

1
Address requirement for parent-child relationship filtering (Accounts with Active Recurring Donations)
Identify that standard field filters cannot evaluate child record existence, so a Cross Filter (Accounts WITH Recurring Donations) must be added.
Cross Filters enable filtering of primary object records based on whether related child records exist.
2
Address requirement for grouping numeric values into custom categories without custom fields
Identify that a Bucket Field on the Total Gifts field satisfies creating Tier 1, Tier 2, and Tier 3 ranges directly in the report builder.
Bucket fields allow reporting categorizations without altering object definitions or creating custom fields.
3
Evaluate why alternative options fail to meet the requirements
Summary formulas perform numeric aggregations rather than row bucketing, and row-level formulas cannot evaluate child object existence.
Distinguishing between Cross Filters, Bucket Fields, Summary Formulas, and Row-Level Formulas ensures appropriate tool selection.

Anahtar Kavram

Report Filtering, Filter Logic, Cross Filters, and Bucket Fields
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Report Filtering, Filter Logic, and Bucketing

Bu konudan daha fazla soru