Acompany wants to create a timeline chart to visualize the evolution of its Closed Won opportunities.What are the required parameters to build a lens that displays output similar to the image shown?
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?
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?
Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first
6 months of the year, as shown in the graphic below. Now, UC wants 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 should a CRM Analytics consultant help UC build this lens?
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?