Salesforce Certified Einstein Analytics and Discovery Consultant — Question 11

A company wants to use Einstein Analytics to analyze the trend of their sales pipeline. The company wants to accelerate the sales process. To do so, they need to know the average time an opportunity spends in each stage. This value is not pre-calculated in Salesforce, so a consultant recommends using a dataflow to calculate it.
How can a dataflow be used to calculate the average time an opportunity spends in each stage?

Answer options

• A. flatten Transformation with Offset Expressions to calculate the duration
• B. computeExpression Transformation with SAQL Expression to calculate the duration
• C. computeRelative Transformation with SAQL Expression to calculate the duration
• D. computeRelative Transformation with offset parameter to calculate the duration

Correct answer: D

Explanation

The correct answer is D because the computeRelative Transformation with the offset parameter allows for calculating the duration that an opportunity spends in each stage effectively. Options A, B, and C do not specifically utilize the offset parameter, which is essential for accurately determining the time spent at each stage in this context.