A client has a dashboard that uses a bar chart to visualize sales by Sub-Category and a detail table that has all the orders for the products within Sub-
Category. The table has more than 10,000 rows of data and is slow to load.
A consultant plans to add an action so when the client interacts with the bar chart, only the relevant data appears in the table.
What will provide the fastest rendering of the dashboard?
To optimize the dashboard rendering, particularly when dealing with a large dataset, a filter action is the most effective tool. Here's why the specified choice is optimal:
Add a filter action: This action creates a direct filter on the detail table based on the selection in the bar chart. It ensures that only data related to the selected sub-category is loaded into the table, significantly reducing load time and improving performance.
Set 'Run action on' to Select: This setting means the filter action will be triggered as soon as the user selects a bar in the bar chart. Immediate activation of the filter ensures that the dashboard is interactive and responsive.
Set 'Clearing the selection will' to Exclude all values: When the selection is cleared, this setting ensures that no data is shown, which avoids loading the entire dataset unnecessarily. This maintains performance when no sub-category is actively selected.
Reference This strategy follows Tableau's performance best practices by using actions to limit the amount of data processed and rendered, as detailed in the Tableau User Guide and training materials on Dashboard Actions for optimizing large datasets.
Kattie
2 days agoBrittani
2 days ago