Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline...

Vendor: Salesforce
Product: Analytics-Con-201
Update on: Sep 20, 2026
Questions: 116

Salesforce Analytics-Con-201 Question Answer

Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline in order to accelerate the company's sales process. To do so, CK needs to know the average time an opportunity

spends in each stage. The data can be found in the Opportunity History object, but the value is not pre-calculated in Salesforce, so a consultant recommends using a recipe to calculate it.

How should the consultant use a recipe to calculate the average time an opportunity spends in each stage?

An aggregate transformation with offset parameter to calculate the duration

Flatten transformation with offset expressions to calculate the duration

Custom transformation with a multiple row formula to calculate the duration