ExhibitUniversal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is: YoY = [(This Year — Last Year) / Last Year] % Based on the graphic, when there is not an 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 CRM Analytics consultant has been asked to refactor a dashboard so that it loads quicker. After some analysis, the consultant found that most of the dashboard queries run in less than 5 seconds; however, the Opportunities Table takes more time to load when scrolled down from its initial view. How should the consultant improve the performance of this dashboard?

The CRM Analytics consultant at Universal Containers notices that some users have access to sensitive data and dashboards they should not have access to in the Manager's app. How should the consultant fix the problem?

ExhibitUniversal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is: YoY = [(This Year — Last Year) / Last Year] % Based on the graphic, when there is not an 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 data architect wants to use a recipe transformation to implement row level security based on role hierarchy in Salesforce. Which transformation should the architect use to level the dataset hierarchy?