Worksheet and Dashboard Actions in Tableau – Complete Detailed Notes

Topic: Worksheet Actions and Dashboard Actions in Tableau

Course: Tableau Training

Learning Objective: Understand how Tableau actions work, create interactive worksheets and dashboards, configure filter and highlight actions, navigate between sheets, open external URLs, change parameters and sets, and build practical business dashboards.

1. Introduction to Worksheet and Dashboard Actions

Tableau is a powerful data visualization and business intelligence tool that helps users explore data through charts, tables, maps, and dashboards. Worksheets and dashboards become more useful when users can interact with visualizations instead of only viewing static charts.

Actions in Tableau are interactive features that respond to user activities such as clicking a data point, hovering over a mark, or selecting an option from a tooltip menu. Depending on the action configuration, Tableau can filter data, highlight related marks, navigate to another sheet, open a webpage, or update a parameter or set.

For example, suppose a sales dashboard contains a map, a bar chart, and a customer table. When a user clicks Maharashtra on the map, the bar chart and customer table can update to display information related to Maharashtra. This behavior is created using a filter action.

1.1 What Is a Worksheet Action?

A worksheet action is an interaction configured from a Tableau worksheet. It allows users to interact with marks in a visualization and trigger a response in the same view, another worksheet, a dashboard, or an external resource, depending on the action type and configuration.

Example: In a worksheet showing sales by product, clicking a product can highlight related marks or open a related detail view.

1.2 What Is a Dashboard Action?

A dashboard action is an interaction configured for a Tableau dashboard. It commonly connects multiple worksheets so that an action performed in one view changes or controls another view.

Example: A sales dashboard contains a regional map, a category chart, and an order table. Selecting a region on the map filters the other views to show the selected region's information.

1.3 Worksheet Actions vs. Dashboard Actions

2. Why Are Actions Important in Tableau?

Actions allow users to explore business data dynamically and discover information without manually changing multiple filters or opening separate reports.

• Interactive analysis: Users can click or hover over marks to explore specific data points.
• Cross-sheet communication: Information from one worksheet can affect another worksheet.
• Reduced dashboard clutter: A single chart can act as an interactive control instead of requiring many visible filters.
• Faster decision-making: Users can investigate regions, products, customers, or time periods quickly.
• Better navigation: Users can move from summary charts to detailed reports.
• External information: URL actions can connect data points to relevant websites or resources.
• Advanced analysis: Parameter and set actions support more flexible analytical experiences.

2.1 Common Business Applications

3. Understanding Marks, Source Sheets, and Target Sheets

Before creating actions, it is important to understand three basic Tableau concepts.

3.1 Marks

A mark is a visual representation of data in a Tableau view. It may appear as a bar, circle, square, map symbol, line, or text value.

For example, in a bar chart showing sales by category, each bar represents a category. Clicking a bar can trigger an action associated with that mark.

3.2 Source Sheet

The source sheet is the worksheet where the interaction begins. It contains the marks that users select, hover over, or use to trigger an action.

Example: A map showing sales by state is the source sheet when a user clicks a state to filter a sales chart.

3.3 Target Sheet

The target sheet is the worksheet or view that receives the action. It may display filtered information, highlighted marks, or a related detail view.

Example: A customer table is the target sheet when selecting a state on a map filters the table to customers from that state.

3.4 Source and Target Example

Source Sheet: Sales by Region Map
          |
          | User selects a region
          v
Action: Filter
          |
          v
Target Sheet 1: Sales by Category
Target Sheet 2: Customer Details
Target Sheet 3: Monthly Sales Trend

The exact behavior depends on the action type, selected source and target sheets, fields used, and clearing-selection settings.

4. Types of Actions in Tableau

Tableau provides several action types. The most commonly used are filter, highlight, URL, and sheet navigation actions. Parameter and set actions support more advanced interactions.

Note: Available options and interface labels can vary by Tableau version and authoring environment. Tableau also provides other interaction features, such as navigation objects and dashboard filter controls, that may be more suitable for particular requirements.

5. Filter Actions in Tableau

A filter action passes selected field values from a source view to a target view and filters the target based on those values. It is one of the most frequently used actions in interactive dashboards.

5.1 Example of a Filter Action

Imagine a dashboard containing three worksheets:

• Worksheet 1: Sales by State
• Worksheet 2: Sales by Product Category
• Worksheet 3: Customer Order Details

When the user selects Gujarat in the state chart, the other two worksheets can update to display data associated with Gujarat.

Sales by State
      |
      | Select Gujarat
      v
   Filter Action
      |
      +------> Sales by Product Category
      |
      +------> Customer Order Details

5.2 Steps to Create a Filter Action

1. Connect Tableau to a suitable dataset, such as Sample - Superstore.
2. Create a worksheet named Sales by State.
3. Place State on Rows and Sales on Columns to create a bar chart.
4. Create another worksheet named Sales by Category.
5. Place Category on Rows and Sales on Columns.
6. Create a third worksheet named Order Details using appropriate order, customer, product, and sales fields.
7. Create a dashboard and add all three worksheets.
8. Select Dashboard > Actions.
9. Click Add Action > Filter.
10. Enter a descriptive name, such as Filter Views by State.
11. Under Source Sheets, select Sales by State.
12. Under Run action on, choose Select, Hover, or Menu according to the required behavior.
13. Under Target Sheets, select Sales by Category and Order Details.
14. Configure the behavior for clearing the selection.
15. Choose All Fields or Selected Fields, depending on the fields that should be passed.
16. Click OK to save the action, then test it by selecting a state.

These steps follow Tableau's standard filter-action workflow. Read the official Tableau Filter Actions documentation.

5.3 Run Action On Options

5.4 Clearing the Selection

Tableau provides options for handling the target view after the user clears a selection. Depending on the authoring environment, labels can differ.

• Show all values: Restore the target to display all available values.
• Leave the filter: Keep the previously filtered result.
• Exclude all values: Display no matching values, which can be useful for intentionally hiding a detail view until a selection is made.

Choose the behavior that makes the dashboard easiest to understand. For general-purpose business dashboards, restoring all values is often a reasonable default.

5.5 All Fields vs. Selected Fields

All Fields: Tableau passes the applicable field values from the source view to the target. This can create more restrictive filtering when multiple fields define the selected mark.

Selected Fields: You choose the exact source and target fields used by the action. This gives greater control, particularly when the views use different field names or when only one shared business dimension should control the interaction.

Example: A source worksheet contains Region and Category. If only Region is mapped to the target, selecting a category within a region will not necessarily filter the target by Category. The action uses the field mapping you configured.

6. Highlight Actions in Tableau

A highlight action emphasizes selected or related marks while keeping other marks visible. Unlike a filter action, it generally does not remove the other marks from the view.

6.1 Example

Suppose a dashboard shows sales by category, sales by region, and profit by product. When a user selects Furniture, the related Furniture marks can be highlighted across the target views while the other categories remain visible.

6.2 Steps to Create a Highlight Action

1. Create two or more worksheets that contain related data.
2. Add them to a dashboard.
3. Select Dashboard > Actions.
4. Click Add Action > Highlight.
5. Enter a descriptive name, such as Highlight Selected Category.
6. Choose the source worksheet or worksheets.
7. Choose the action trigger: Hover, Select, or Menu.
8. Select the target worksheets that should respond.
9. Choose All Fields, Dates and Times, or Selected Fields, as appropriate.
10. Click OK and test the action by hovering over or selecting marks.

For additional details, see Tableau's official advanced highlight actions guide.

6.3 Filter Action vs. Highlight Action

7. Go to URL Actions

A Go to URL action allows users to open a website, a web resource, or another supported URL when they interact with a mark. URL actions can use field values to construct a data-driven destination.

7.1 Practical Example

Imagine a product analysis dashboard. Each product has a Product ID or product page URL. Clicking a product can open the corresponding product details page.

7.2 Steps to Create a URL Action

1. Create a worksheet with a field that identifies the relevant entity, such as Product ID, State, or Customer ID.
2. Add the worksheet to a dashboard.
3. Open Dashboard > Actions.
4. Click Add Action > Go to URL.
5. Enter a descriptive action name.
6. Select the source worksheet.
7. Choose Hover, Select, or Menu as the trigger.
8. Enter the destination URL, beginning with a valid protocol such as https://.
9. If required, insert supported field values as dynamic URL parameters.
10. Choose the appropriate URL target. If the destination should appear inside the dashboard, configure a compatible Web Page object where supported.
11. Save the action and test the destination with representative data.

7.3 Dynamic URL Example

Suppose a dataset contains a State field and the goal is to open a search page for the selected state. A URL can include the selected state as a dynamic value. The precise URL template depends on the destination website and the supported URL syntax in Tableau.

Base destination:
https://www.example.com/search?state=

Concept:
Base destination + selected State value

Illustrative result:
https://www.example.com/search?state=Maharashtra

The example uses a fictional destination. For production dashboards, confirm the destination site's URL format and safely handle special characters in dynamic values. Avoid exposing confidential information through URL parameters.

8. Go to Sheet Actions

A Go to Sheet action enables users to navigate from a source view to another worksheet, dashboard, or story destination supported by Tableau. It is useful for creating a drill-down experience from summary information to detailed analysis.

8.1 Example

A management dashboard displays overall revenue by region. When a user selects a region, a navigation action can take them to a detailed regional analysis dashboard.

8.2 Steps to Create a Go to Sheet Action

1. Create the source worksheet that contains selectable marks.
2. Create the destination worksheet or dashboard.
3. Open the dashboard containing the source view.
4. Select Dashboard > Actions.
5. Click Add Action > Go to Sheet.
6. Provide a meaningful action name.
7. Select the source sheet.
8. Choose Select or Menu as the trigger, depending on the intended navigation experience.
9. Choose the destination sheet, dashboard, or supported story target.
10. Save the action and test the navigation.

Use a clear name such as Open Regional Sales Details so users understand the purpose of the action. For direct navigation that does not depend on selecting a mark, a dashboard Navigation object may be more suitable.

9. Change Parameter Actions

A parameter action allows a user interaction with a mark to update a Tableau parameter. Parameters can control calculations, reference lines, selected measures, comparison targets, or other parts of an analytical view.

9.1 Example

A dashboard contains sales by product. Clicking a product updates a parameter that stores the selected product name. A calculated field can then use that parameter to display information or compare the selected product against others.

9.2 General Steps

1. Create a parameter with a suitable data type and initial value.
2. Use the parameter in a calculated field or another supported Tableau feature.
3. Create a worksheet containing the marks that should update the parameter.
4. Open Dashboard > Actions.
5. Click Add Action > Change Parameter.
6. Select the source worksheet and trigger behavior.
7. Select the target parameter.
8. Choose the source field whose value will be assigned to the parameter.
9. Configure the clearing behavior and save the action.
10. Test the parameter by selecting different marks.

Parameter actions are useful when the user needs to control a calculation or selected value rather than simply filter a target view.

10. Change Set Values Actions

A set action allows a user to change the members of a Tableau set through interactions with marks. Sets define a group of data members that meet a condition or have been selected for analysis.

10.1 Example

A sales manager selects several customers in a chart. A set action updates a customer set, which can then be used to compare selected customers with all other customers.

10.2 General Steps

1. Create a set based on a dimension, such as Customer Name.
2. Build a worksheet using the relevant dimension and measures.
3. Add the worksheet to a dashboard.
4. Open Dashboard > Actions.
5. Click Add Action > Change Set Values.
6. Choose the source worksheet and triggering behavior.
7. Select the target set.
8. Configure how selected members are added, removed, or assigned according to the available options.
9. Save and test the action with several marks.

Set actions are especially useful for selected-versus-other comparisons, customer segmentation, cohort analysis, and interactive product selection.

11. Creating an Interactive Dashboard from Multiple Worksheets

A dashboard can combine multiple worksheets into one analytical interface. Actions connect those views so that users can explore the data naturally.

11.1 Recommended Dashboard Structure

• Top section: KPI cards for Sales, Profit, Orders, and Profit Ratio.
• Left section: Sales by Region or State.
• Center section: Sales by Category or Product.
• Right section: Monthly Sales Trend.
• Bottom section: Customer or Order Details table.

11.2 Example Interaction Flow

Interactive Sales Dashboard
          |
          v
User selects a region
          |
          v
Filter Action
          |
          +------> KPI Cards update
          |
          +------> Category Chart updates
          |
          +------> Monthly Trend updates
          |
          +------> Order Details update
          |
          v
User selects a category
          |
          v
Further exploration of category performance

11.3 Best Practices for Dashboard Actions

• Give actions descriptive names.
• Use consistent fields to connect related views.
• Keep the number of interactions manageable.
• Provide clear instructions, such as “Select a region to filter the dashboard.”
• Choose Hover for lightweight exploration and Select for deliberate actions.
• Use highlight actions when retaining context is important.
• Use filter actions when users need to focus on a subset of records.
• Test clearing selections and multiple selections.
• Ensure the dashboard behaves predictably on Tableau Desktop, Cloud, or Server as applicable.
• Review performance when actions affect many worksheets or large datasets.

See Tableau's official documentation on actions and dashboards for examples of connecting views and navigating between sheets.

12. Practical Project: Interactive Retail Sales Dashboard

Project Objective: Build an interactive dashboard that allows managers to analyze sales and profit by region, category, and customer.

12.1 Dataset Requirements

You can use Tableau's Sample - Superstore dataset or a similar sales dataset containing fields such as Order Date, Region, State, Category, Sub-Category, Product Name, Customer Name, Sales, Profit, and Quantity.

12.2 Create the Worksheets

1. Sales by Region: Create a bar chart with Region and Sales.
2. Sales by Category: Create a bar chart with Category and Sales.
3. Monthly Sales Trend: Place Order Date on Columns and Sales on Rows, using a suitable date level.
4. Profit by Product: Create a chart with Product Name and Profit.
5. Order Details: Create a table containing relevant order, customer, product, sales, and profit fields.

12.3 Assemble the Dashboard

1. Create a new dashboard.
2. Place the regional chart prominently.
3. Add the category chart, trend chart, product chart, and detail table.
4. Arrange the views using tiled containers or a suitable layout.
5. Give the dashboard a clear title and add short interaction instructions.

12.4 Configure Actions

12.5 Testing Checklist

• Click each region and confirm that intended target sheets respond.
• Clear the selection and confirm that the configured reset behavior works.
• Test different categories and products.
• Check that the action uses the correct field mappings.
• Confirm that URL destinations are valid and safe.
• Verify that navigation actions open the intended destination.
• Test the dashboard at different screen sizes.
• Check for slow performance or confusing interactions.

12.6 Expected Outcome

The completed dashboard allows managers to move from a high-level sales summary to regional, category, product, and order-level information without manually rebuilding individual reports.

13. Troubleshooting Common Action Problems

14. Performance and Design Recommendations

• Design for a purpose: Every action should support a specific analytical task.
• Avoid unnecessary interactions: Too many actions can confuse users and increase maintenance effort.
• Use meaningful labels: Names such as “Filter by Region” are more understandable than generic names.
• Choose the right trigger: Hover is suitable for quick exploration; Select is better when an intentional click is needed.
• Preserve analytical context: Highlight actions can be better than filters when comparisons are important.
• Check field compatibility: Source and target fields should represent compatible values and data types.
• Optimize worksheets: Reduce unnecessary marks and expensive calculations where possible.
• Validate user access: Ensure users have permission to access linked resources and published content.
• Protect sensitive information: Do not expose confidential identifiers or data in URLs.
• Test real workflows: Verify actions with realistic selections, empty results, and cleared selections.

15. Interview Questions and Answers

Q1. What is an action in Tableau?

Answer: An action is an interactive feature that responds to user interactions with marks or menus and can filter data, highlight marks, navigate to another sheet, open a URL, or change parameter or set values.

Q2. What is the difference between a worksheet action and a dashboard action?

Answer: Worksheet actions are configured from a worksheet context, while dashboard actions are commonly used to connect multiple views and coordinate interactions within a dashboard. The available targets and behavior depend on the action type and configuration.

Q3. What is a filter action?

Answer: A filter action sends selected field values from a source view to a target view and filters the target to show related data.

Q4. What is a highlight action?

Answer: A highlight action emphasizes matching marks while keeping other marks visible, helping users compare selected data with the rest of the visualization.

Q5. When should you use a filter action instead of a highlight action?

Answer: Use a filter action when users need to focus on a subset of records. Use a highlight action when users need to see selected marks in the context of the entire dataset.

Q6. What is a source sheet?

Answer: The source sheet is the worksheet where the user interaction starts and from which the action receives selected values.

Q7. What is a target sheet?

Answer: The target sheet is the view that responds to the action, such as by displaying filtered data or highlighting related marks.

Q8. What are the three common action triggers?

Answer: Hover, Select, and Menu.

Q9. What is a URL action?

Answer: A URL action opens a web resource or other supported URL destination. It can use field values to create a dynamic destination.

Q10. What is a Go to Sheet action?

Answer: It allows a user to navigate to another supported worksheet, dashboard, or story destination from an interactive view.

Q11. What is the purpose of a parameter action?

Answer: It updates a parameter value through interaction with marks, allowing the parameter to control calculations or other analytical behavior.

Q12. What is the purpose of a set action?

Answer: It changes membership in a set through user interaction and supports selected-versus-other analysis and interactive segmentation.

Q13. What happens when a user clears a filter action selection?

Answer: Tableau follows the configured clearing behavior, such as restoring all values, retaining the previous filter, or excluding all values.

Q14. What is the difference between All Fields and Selected Fields in a filter action?

Answer: All Fields uses the applicable fields from the source mark, while Selected Fields lets the author specify which source and target fields should control the filtering.

Q15. How can you make a dashboard more user-friendly?

Answer: Use descriptive action names, clear instructions, appropriate triggers, consistent field mappings, predictable reset behavior, and a limited set of meaningful interactions.

16. Practice Exercises

1. Create a bar chart of sales by region and use it to filter a category chart.
2. Create a highlight action that emphasizes a selected product category across two views.
3. Configure a filter action to use Selected Fields and test the result.
4. Create a URL action that opens an appropriate external page using a field value.
5. Build a summary-to-detail navigation workflow using a Go to Sheet action.
6. Create a parameter action that updates a parameter from a selected mark.
7. Create a set action that supports comparing selected customers with other customers.
8. Test all configured actions when a selection is cleared.
9. Document the purpose, source, target, trigger, and expected behavior of each action.
10. Publish or share the dashboard in an appropriate environment and verify that the actions work as expected.

17. Quick Revision Checklist

• Understand the meaning of worksheet and dashboard actions.
• Know the difference between source sheets and target sheets.
• Understand filter, highlight, URL, Go to Sheet, parameter, and set actions.
• Know the Hover, Select, and Menu triggers.
• Understand All Fields and Selected Fields.
• Configure and test clearing-selection behavior.
• Build a dashboard that connects multiple worksheets.
• Recognize common action problems and their solutions.
• Follow good practices for usability, performance, and data privacy.

18. Conclusion

Worksheet and dashboard actions are important Tableau features that transform visualizations into interactive analytical tools. Filter actions help users focus on specific records, highlight actions preserve context while emphasizing related marks, URL actions connect data to external resources, and Go to Sheet actions improve navigation. Parameter and set actions enable more advanced forms of interactive analysis.

By combining the correct action types with clear dashboard design, appropriate field mappings, predictable selection behavior, and thorough testing, you can build dashboards that make business data easier to explore and understand.

19. Official Learning Resources

• Tableau Actions – Official Documentation
• Tableau Filter Actions
• Tableau Actions and Dashboards
• Tableau Dashboard Learning Resources

20. Tableau Training and Course Demo

Learn more about Tableau concepts, data visualization, interactive dashboards, and business intelligence through the following course resources:

Explore Tableau Training

Register for a Tableau Course Demo