In this section, we will explore how to add interactivity to your Tableau dashboards using dashboard actions. Dashboard actions allow users to interact with the data visualizations, making the dashboards more dynamic and insightful.
Key Concepts
-
Types of Dashboard Actions:
- Filter Actions: Allow users to filter data across multiple sheets.
- Highlight Actions: Highlight specific data points across multiple sheets.
- URL Actions: Navigate to a web page or another Tableau dashboard.
- Go to Sheet Actions: Navigate to a different sheet within the workbook.
-
Creating Dashboard Actions:
- How to create and configure different types of actions.
- Understanding the scope and impact of each action.
-
Practical Examples:
- Step-by-step examples of creating and using dashboard actions.
-
Best Practices:
- Tips for effectively using dashboard actions to enhance user experience.
Creating Dashboard Actions
Filter Actions
Filter actions allow users to filter data across multiple sheets by selecting data points in one sheet.
Steps to Create a Filter Action:
-
Open the Dashboard:
- Open the dashboard where you want to add the filter action.
-
Go to Dashboard Menu:
- Click on the
Dashboard
menu and selectActions
.
- Click on the
-
Add Action:
- Click on
Add Action
and selectFilter
.
- Click on
-
Configure the Action:
- Source Sheets: Select the sheet(s) that will trigger the action.
- Target Sheets: Select the sheet(s) that will be affected by the action.
- Run Action On: Choose when the action should run (Hover, Select, or Menu).
- Clearing the Selection: Decide what happens when the selection is cleared (Show all values, Keep filtered values, or Exclude all values).
-
Save and Test:
- Click
OK
to save the action and test it by interacting with the source sheet.
- Click
Example Code Block
1. Open your dashboard. 2. Go to `Dashboard` > `Actions`. 3. Click `Add Action` > `Filter`. 4. In the `Edit Filter Action` dialog box: - Name the action (e.g., "Filter Sales by Region"). - Select the source sheet (e.g., "Sales Map"). - Select the target sheet (e.g., "Sales Details"). - Choose `Run action on: Select`. - Set `Clearing the selection will: Show all values`. 5. Click `OK` to save the action. 6. Test the action by selecting a region on the "Sales Map" sheet.
Highlight Actions
Highlight actions emphasize specific data points across multiple sheets.
Steps to Create a Highlight Action:
-
Open the Dashboard:
- Open the dashboard where you want to add the highlight action.
-
Go to Dashboard Menu:
- Click on the
Dashboard
menu and selectActions
.
- Click on the
-
Add Action:
- Click on
Add Action
and selectHighlight
.
- Click on
-
Configure the Action:
- Source Sheets: Select the sheet(s) that will trigger the action.
- Target Sheets: Select the sheet(s) that will be affected by the action.
- Run Action On: Choose when the action should run (Hover, Select, or Menu).
-
Save and Test:
- Click
OK
to save the action and test it by interacting with the source sheet.
- Click
URL Actions
URL actions allow users to navigate to a web page or another Tableau dashboard.
Steps to Create a URL Action:
-
Open the Dashboard:
- Open the dashboard where you want to add the URL action.
-
Go to Dashboard Menu:
- Click on the
Dashboard
menu and selectActions
.
- Click on the
-
Add Action:
- Click on
Add Action
and selectURL
.
- Click on
-
Configure the Action:
- Source Sheets: Select the sheet(s) that will trigger the action.
- URL: Enter the URL you want to navigate to. You can use field values to dynamically construct the URL.
- Run Action On: Choose when the action should run (Hover, Select, or Menu).
-
Save and Test:
- Click
OK
to save the action and test it by interacting with the source sheet.
- Click
Go to Sheet Actions
Go to Sheet actions allow users to navigate to a different sheet within the workbook.
Steps to Create a Go to Sheet Action:
-
Open the Dashboard:
- Open the dashboard where you want to add the Go to Sheet action.
-
Go to Dashboard Menu:
- Click on the
Dashboard
menu and selectActions
.
- Click on the
-
Add Action:
- Click on
Add Action
and selectGo to Sheet
.
- Click on
-
Configure the Action:
- Source Sheets: Select the sheet(s) that will trigger the action.
- Target Sheet: Select the sheet you want to navigate to.
- Run Action On: Choose when the action should run (Hover, Select, or Menu).
-
Save and Test:
- Click
OK
to save the action and test it by interacting with the source sheet.
- Click
Practical Example
Let's create a practical example where we use a filter action to filter sales data by region.
Step-by-Step Example
-
Create a Sales Map:
- Create a map visualization showing sales by region.
-
Create a Sales Details Sheet:
- Create a detailed table showing sales data.
-
Add Both Sheets to a Dashboard:
- Add the "Sales Map" and "Sales Details" sheets to a dashboard.
-
Create a Filter Action:
- Go to
Dashboard
>Actions
. - Click
Add Action
>Filter
. - Name the action "Filter Sales by Region".
- Select "Sales Map" as the source sheet.
- Select "Sales Details" as the target sheet.
- Choose
Run action on: Select
. - Set
Clearing the selection will: Show all values
. - Click
OK
to save the action.
- Go to
-
Test the Action:
- Select a region on the "Sales Map" sheet and observe the "Sales Details" sheet updating to show only the data for the selected region.
Best Practices
- Keep It Simple: Avoid overloading your dashboard with too many actions, as it can confuse users.
- Clear Instructions: Provide clear instructions or tooltips to guide users on how to interact with the dashboard.
- Test Thoroughly: Always test your actions to ensure they work as expected and provide the desired interactivity.
- Consistent Behavior: Ensure that similar actions behave consistently across different sheets and dashboards.
Conclusion
Dashboard actions are a powerful feature in Tableau that can significantly enhance the interactivity and usability of your dashboards. By using filter, highlight, URL, and Go to Sheet actions, you can create dynamic and engaging visualizations that provide deeper insights into your data. Practice creating different types of actions and experiment with their configurations to fully leverage their potential in your Tableau projects.
Tableau Course
Module 1: Introduction to Tableau
- What is Tableau?
- Installing Tableau
- Tableau Interface Overview
- Connecting to Data Sources
- Basic Data Types and Structures
Module 2: Basic Visualization Techniques
- Creating Your First Visualization
- Using Marks and Cards
- Building Basic Charts
- Filtering Data
- Sorting and Grouping Data
Module 3: Intermediate Visualization Techniques
- Using Calculated Fields
- Creating Dual-Axis Charts
- Using Parameters
- Creating Maps
- Using Table Calculations
Module 4: Advanced Visualization Techniques
- Advanced Chart Types
- Using LOD Expressions
- Creating Dashboards
- Dashboard Actions
- Storytelling with Data
Module 5: Data Preparation and Transformation
Module 6: Advanced Analytics
Module 7: Performance Optimization
- Optimizing Workbook Performance
- Extracts vs Live Connections
- Reducing Load Times
- Performance Recording
- Best Practices for Performance
Module 8: Tableau Server and Online
- Introduction to Tableau Server
- Publishing Workbooks
- Managing Permissions
- Scheduling Extracts
- Collaborating with Tableau Online