Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 41

An Einstein Analytics Consultant is working with a subscriptions based company to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account can only have one active subscription. Unfortunately, the Opportunity record does not specify whether it is a renewal or a net new subscription.
Which data transformation should be used to determine if a subscription is new or a renewal?

Answer options

Correct answer: D

Explanation

The correct answer is D, flatten, because this transformation allows for the merging of data from related records, which can help identify renewals by comparing current subscriptions with historical data. The other options, while useful for different types of calculations or transformations, do not provide the necessary functionality to distinguish between new subscriptions and renewals in this context.