Exit ANC-301 Working with Data and Dashboards in Einstein Analytics (ANC-301)
Question 5 of 5
0% complete
Q5 Single choice

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

    replace()

  • B

    number_to_string()

  • C

    coalesce()

  • D

    substr()

Previous Save & finish