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

Actual exam question from Salesforce's Certified Tableau CRM and Einstein Discovery Consultant

Question #: 37
Topic #: 1

[All Certified Tableau CRM and Einstein Discovery Consultant Questions]

Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year - Last Year) /
Last Year] %
Based on the graphic, when there is no account in the Last Year column, the YoY Growth shows null results. The Sales Managers want to replace it with 100% value.
What is the correct function to use?

A. coalesce()
B. number_to_string()
C. substr()
D. replace()

Show Suggested Answer

Suggested Answer: A 🗳️

by snusmumrick at Aug. 21, 2022, 7:41 p.m.

Comments

Submit Cancel

840acea

5 months ago

Selected Answer: A

https://developer.salesforce.com/docs/atlas.en-us.232.0.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_coalesce.htm

upvoted 1 times

...

RMEZZA

11 months ago

A. Coalesce() is the correct one

upvoted 1 times

...

snusmumrick

2 years, 2 months ago

Correct! A. coalesce() can be used for replacing a null value with another value. https://developer.salesforce.com/docs/atlas.en-us.232.0.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_coalesce.htm FYI, D. replace() are incorrect because it always returns a null value if the input is a null value.

upvoted 3 times

...

snusmumrick

2 years, 2 months ago

Question was on exam 21 August 2022.

upvoted 1 times

...

Exam Certified Tableau CRM and Einstein Discovery Consultant All Questions

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

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

Comments

840acea

RMEZZA

snusmumrick

snusmumrick

SY0-701