Examkin

Soru

Zorluk: OrtaReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at an automotive fleet management company is creating an Opportunity report to evaluate vehicle leasing pipeline records. The leadership team requests the following report criteria:

1. Include deals with an Amount greater than $100,000 OR deals in the 'Negotiation/Review' stage.
2. Exclusively restrict results to accounts headquartered in 'California' or 'Texas', regardless of amount or stage.
3. Include only opportunities whose parent Account has at least one related Service Contract record.

The administrator creates three field filters:
- Filter 1: Amount > 100000
- Filter 2: Stage equals Negotiation/Review
- Filter 3: Billing State/Province equals California, Texas

Which TWO configuration steps must the administrator take to meet these business requirements?

  1. Set the report filter logic string to (1 OR 2) AND 3.Cevap
  2. Add a Cross Filter on the report for Opportunities with Accounts, with a sub-filter of Service Contracts with Count greater than or equal to 1.Cevap
  3. C
    Set the report filter logic string to 1 OR (2 AND 3).
  4. D
    Create a bucket field on the Account object to filter out opportunities without related service contracts.

Cevap

The administrator must set the report filter logic to (1 OR 2) AND 3 and add a Cross Filter for Opportunities with Accounts having related Service Contracts.
Configuring filter logic as (1 OR 2) AND 3 correctly groups the alternative opportunity conditions while ensuring the geographic boundary is enforced across all records. Adding a Cross Filter dynamically evaluates whether related service contracts exist for each account without requiring custom code or roll-up fields.

Adım Adım Çözüm

1
Evaluate the Boolean logic needed for the standard field filters.
Filters 1 (Amount) and 2 (Stage) represent alternative criteria that must be grouped together with OR, whereas Filter 3 (State) is a mandatory condition that must be combined with AND.
Ensures that state restriction applies universally to both high-value deals and deals in negotiation.
2
Determine the proper tool to filter by related child object presence.
A Cross Filter configured for Opportunities with Accounts, filtered by related Service Contracts.
Standard report field filters operate on fields directly accessible on the report type, while Cross Filters enable conditional filtering based on related child object relationships.

Anahtar Kavram

Report Boolean Filter Logic and Cross Filters
Bu soruyu puanla

Konular

Report Filtering, Filter Logic, and Bucketing

Bu konudan daha fazla soru