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 questionsTo 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.
Keep practicing
Take the free CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT practice questions
- Question 1Universal Containers has a single dataset that contains the attainment and commission fie…
- Question 2A client has two datasets that are used across seven different dashboards. Three of these…
- Question 3A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a f…
- Question 5CRM Analytics team is asked to build a Service Analytics dashboard for the service agents…
- Question 6A system administrator and a CRM Analytics consultant are working together on deploying a…
- Question 7Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information…
