CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT practice question 12 of 25

Universal Containers’ sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard. Which action is required to accomplish this?

Full set: 115 questions
Answer options
A: Create a query and sort descending by revenue and limit it to 10 results. Correct answer
B: Create a query with a results based interaction as a filter using the limit query to pass in the 10 Account IDs.
C: Create 2 query with a selection based interaction as a filter using the limit query to pass in the 10 Account IDs.
Correct Answer:
A. Create a query and sort descending by revenue and limit it to 10 results.
Explanation

To create a dashboard showing the top 10 accounts by revenue dynamically, the best approach is to create a query that sorts the accounts in descending order by revenue and limits the results to the top 10. This query can then be used as the data source for the widget, ensuring that it dynamically adjusts based on the filters applied to the dashboard. This method efficiently handles the task because sorting by revenue and limiting the results to 10 ensures that only the top accounts are displayed, and it remains dynamic with dashboard filters.
Reference: This approach is covered in the Building Lenses, Dashboards, and Apps in CRM Analytics module, where techniques for creating dynamic queries are discussed.

Scroll to Top