Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) CRM-Analytics-and-Einstein-Discovery-Consultant Question # 3 Topic 1 Discussion

Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) CRM-Analytics-and-Einstein-Discovery-Consultant Question # 3 Topic 1 Discussion

CRM-Analytics-and-Einstein-Discovery-Consultant Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing

the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

CRM-Analytics-and-Einstein-Discovery-Consultant Question 3

How should a CRM Analytics consultant help UC build this lens?


A.

Use a "fill" statement in SAQL query with a "partition" parameter.


B.

Use a “Compare Table" and add a column leveraging the “Running Total” function.


C.

Use a "Compare Table" and use the "Show Totals" option.


Get Premium CRM-Analytics-and-Einstein-Discovery-Consultant Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.