Examkin

Soru

Zorluk: OrtaReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a pharmaceutical distribution company is creating a custom Account report for the customer success team. The management team requires the report to meet two specific operational criteria:
1. Only display Accounts that have related support Cases with a Priority of 'High' or 'Critical' that are currently Open.
2. Categorize Accounts into three revenue tiers ('Tier 1', 'Tier 2', and 'Tier 3') based on their Annual Revenue ranges directly within the report, without creating any custom fields on the Account object.

Which TWO configuration actions should the administrator perform in the Report Builder to fulfill these business requirements?

  1. Add a Cross Filter setting the report to Accounts WITH Cases, and add a secondary sub-filter where Case Status equals Open AND Case Priority equals High, Critical.Cevap
  2. Create a Bucket Field based on the Annual Revenue field on the Account object, defining ranges for Tier 1, Tier 2, and Tier 3.Cevap
  3. C
    Write a Summary Formula field in the report to evaluate individual record values of Annual Revenue and assign tier labels to each Account row.
  4. D
    Configure Dynamic Forms component visibility settings on the Account Lightning Page layout to filter visible records dynamically based on open case criteria.

Cevap

The administrator must add a Cross Filter for Accounts WITH Cases with sub-filters for open status and high/critical priority, and create a Bucket Field on the Annual Revenue numeric field to establish the three revenue tiers.
The solution requires two distinct Report Builder features. First, filtering parent records based on child record conditions (Accounts with specific Open Cases) is accomplished using a Cross Filter with secondary sub-filters on the child object fields. Second, categorizing numeric field values (Annual Revenue) into defined ranges ('Tier 1', 'Tier 2', 'Tier 3') directly in the report without creating schema-level custom fields is accomplished using a Bucket Field.

Adım Adım Çözüm

1
Configure record relationship filtering
Accounts are filtered based on related Case attributes.
Using a Cross Filter of 'Accounts WITH Cases' along with sub-filters ('Status equals Open' and 'Priority equals High, Critical') isolates Accounts meeting the child record condition.
2
Add a Bucket Field on Annual Revenue
Accounts are grouped into Tier 1, Tier 2, and Tier 3 ranges.
Bucket fields provide report-level grouping for numeric fields like Annual Revenue without adding schema metadata (custom fields) to the Account object.

Anahtar Kavram

Report Cross Filters and Bucket Fields
Bu soruyu puanla

Konular

Report Filtering, Filter Logic, and Bucketing

Bu konudan daha fazla soru