A shipping company created a dataset, "Book11," containing budget per region per month for the first six months of 2018. The dataset is shown in the graphic.
Now, they want 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.
How can a Tableau CRM Consultant help this company build this lens?

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

B. Use a "Compare Table" and use the "Show summary" option.

C. Use a SAQL query leveraging the "fill" statement with a "partition" parameter.

D. Use a SAQL query to create fake rows for any data that is missing data from the dataset.








 

Suggested Answer: C





This question is in Certified Tableau CRM and Einstein Discovery Consultant Exam
For getting Salesforce Certified Tableau CRM and Einstein Discovery Consultant















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.