Bobahaven has been using Salesforce Service Cloud for some time and has recently implemented Public Sector Solutions to improve its application and…

The Public Sector Case Analytics App is a pre-built CRM Analytics application specifically designed for public sector use cases, including case management. It provides out-of-the-box dashboards and datasets for analyzing trends in case resolution, agent performance, and constituent satisfaction. A key feature of CRM Analytics is its ability to perform complex calculations, such as case duration (time between creation and closure), on the fly using formulas within its dataflows or lenses. This approach provides powerful trend reporting capabilities without requiring any customization to the core Salesforce Case object, such as adding new fields, thus perfectly aligning with the requirement to minimize customization.

A. Standard Salesforce Report using the standard Case report type, with a newly created custom field to track case duration for new cases.

This option requires creating a custom field and automation (like a Flow) to populate it, which is more customization than necessary and violates the "minimize customization" principle.

C. Standard Salesforce Report using the standard Case report type, with a custom formula to calculate case duration.

While this uses a formula and avoids a custom field, standard reports offer limited capabilities for the deep, ongoing trend analysis that an executive team typically requires, compared to CRM Analytics.

D. Public Sector Case Analytics App, with a newly created custom field to track case duration for new cases.

This is incorrect because creating a custom field is redundant. The Public Sector Case Analytics App can already calculate case duration using its own formulas, making the custom field an unnecessary customization.

1. Salesforce Official Documentation, Public Sector Solutions Developer Guide, "Analytics for Public Sector Solutions": This section details the pre-packaged CRM Analytics apps available for Public Sector Solutions. It states, "Public Sector Solutions provides templated CRM Analytics apps with ready-to-use dashboards, lenses, and datasets... Use the Public Sector Case Analytics app to get insights into case trends, service backlogs, and agent performance." This confirms the existence and purpose of the app.

2. Salesforce Official Documentation, CRM Analytics Prebuilt Apps Guide, "Public Sector Case Analytics App": This guide describes the dashboards included in the app, such as the "Case Overview" dashboard, which is designed to display key metrics like "Average Time to Close." This demonstrates its out-of-the-box capability to report on case duration.

3. Salesforce Official Documentation, CRM Analytics Data Integration Guide, "Compute Expression Transformation": This document explains how CRM Analytics dataflows can create new fields based on calculations from existing fields. For case duration, a formula like daysBetween(CloseDate, CreatedDate) can be used. This confirms that CRM Analytics can calculate the metric without altering the source Salesforce object, thus minimizing customization.