Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Tableau CRM and Einstein Discovery Consultant All Questions

View all questions & answers for the Certified Tableau CRM and Einstein Discovery Consultant exam
Go to Exam

Exam Certified Tableau CRM and Einstein Discovery Consultant topic 1 question 34 discussion

Actual exam question from Salesforce's Certified Tableau CRM and Einstein Discovery Consultant
Question #: 34
Topic #: 1
[All Certified Tableau CRM and Einstein Discovery Consultant Questions]


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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by snusmumrick at Sept. 14, 2022, 8:18 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
RMEZZA
11 months, 1 week ago
C is correct
upvoted 2 times
...
Volovitch
1 year, 11 months ago
I review the questions in my dev org. I still cannot tell for sure the right answer. A : No, running total is not working because it needs 2 measures and 1 dimension. Here Date is not a measure (but a date) and the function is greyed out (even though one could extract the month in a dataflow/recipe). B : Maybe. I can obtain what is descried using the "show subtotal" setting of Compare table with the proper grouping, or pivot table. However "show subtotal" is different than "show summary" in description. I don't know what they refer to with "show summary". C : Maybe. I guess It could work indeed and fill the gaps (there could be a date gap, where no data is reported for specific month, for example). I realize that this "fill" function is what should be used for the 1st challenge of the superbadge, by the way. D : I might miss the point here but why create a fake row for a missing data, it makes no sense...
upvoted 1 times
...
snusmumrick
2 years, 2 months ago
Correct! https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_fill.htm
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel