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…

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.