Examkin

Soru

Zorluk: ZorReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a nationwide logistics provider needs to configure a custom Cases report to analyze service operations. The report must satisfy the following business requirements:
1. Categorize records into three resolution timeframe categories based on the numeric custom field 'Age (Days)': 'Critical' (greater than 14 days), 'Moderate' (5 to 14 days), and 'Prompt' (less than 5 days).
2. Display only Accounts that have closed cases with a Priority of 'High', while explicitly excluding Accounts that currently have any open Escalated cases.

Which two report builder configurations should the administrator implement to meet these requirements? (Select two.)

  1. Add a Bucket Field based on the numeric 'Age (Days)' field, defining ranges for 'Critical', 'Moderate', and 'Prompt'.Cevap
  2. Add two Cross Filters on the report: 'Accounts with Cases' filtered by Status equals Closed and Priority equals High, and 'Accounts without Cases' filtered by Escalated equals True and Closed equals False.Cevap
  3. C
    Create a Row-Level Formula on the report using a CASE() function to group records into timeframes because Bucket Fields do not support numeric field types.
  4. D
    Define standard field filter logic using '1 AND (2 OR NOT 3)' to evaluate cross-object case status and escalation criteria without using Cross Filters.

Cevap

The administrator should add a Bucket Field on the numeric 'Age (Days)' field to group resolution timeframes into ranges, and add two Cross Filters ('Accounts with Cases' and 'Accounts without Cases') with appropriate subfilters to evaluate related case relationships.
Adding a Bucket Field on the numeric 'Age (Days)' field effectively categorizes numerical ranges into custom categories without formulas. Utilizing two Cross Filters ('Accounts with Cases' with secondary subfilters for closed high-priority cases, and 'Accounts without Cases' with secondary subfilters for open escalated cases) correctly evaluates parent-child record relationships.

Adım Adım Çözüm

1
Configure record bucketing for numerical ranges
Created a Bucket Field on the numeric 'Age (Days)' field specifying ranges: >14 ('Critical'), 5 to 14 ('Moderate'), and <5 ('Prompt').
Bucket fields support numeric data types and allow administrators to quickly group ranges of values without creating custom fields or formulas.
2
Apply the first Cross Filter for qualifying related records
Added Cross Filter 'Accounts with Cases' with subfilters: Status = Closed and Priority = High.
Ensures the report only includes parent Account records that have at least one matching closed high-priority case.
3
Apply the second Cross Filter for excluding related records
Added Cross Filter 'Accounts without Cases' with subfilters: Escalated = True and Closed = False.
Excludes parent Account records that have open escalated cases.

Anahtar Kavram

Report Filtering, Filter Logic, and Bucketing
Bu soruyu puanla

Konular

Report Filtering, Filter Logic, and Bucketing

Bu konudan daha fazla soru