Q: 7
An app builder wants to create a report to compare the number of support cases in each status (New, In-progress, or Closed) and by priority (Critical, High, Medium, or Low). What solution should be used for the report?
Options
Discussion
A
A tbh
Option A. Bucket columns can trick you here, but grouping is what actually lets you compare both fields together.
A official trailhead and practice exams both highlight grouping for this type of comparison report.
I think C could also work here since custom report types let you choose which objects and fields show up, so you'd be able to select both status and priority. Not totally sure, but I've used them before when standard ones didn't have the fields I needed. Maybe I'm missing a catch with the comparison part?
A , grouping is what you need if you want to see counts side by side for both status and priority in a single report. That's basically what matrix reports do. Buckets and filters aren't for comparisons across two fields.
B
I remember a similar scenario from labs and went with C. Custom Report Type lets you define extra fields, so thought it would be needed to compare both status and priority in one report. Not 100 percent sure but that's why I picked it. Anyone else do the same?
Grouping (A) is the one you want, since it lets you show both status and priority side by side in the report. Buckets just let you recategorize, not compare fields directly. Seen this style pop up on practice tests, so I’m pretty sure A’s right but open if someone sees a hidden gotcha.
D imo, had something like this in a mock. Grouping does the trick for comparing two fields, status and priority. Confident it's A in this context.
Be respectful. No spam.