Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 96
The 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.
What two steps are required to accomplish this? (Choose two.)
Answer options
- A. Create a query with a selection based interaction as a filter using the limited query to pass in the 10 Account Id's.
- B. Create a query and sort descending by revenue and limit it to 10 results.
- C. Create a query that groups by Account Id and sorts descending by revenue and limit it to 10 results.
- D. Create a query with a results based interaction as a filter using the limited query to pass in the 10 Account Id's.
Correct answer: A, C
Explanation
Option A is correct because it allows for a selection-based filter using specific Account Ids to focus on the top accounts. Option C is also correct as it groups by Account Id and sorts the results, which is necessary for identifying the top 10 based on revenue. Options B and D do not meet the requirements for grouping or sorting effectively for this specific case.