3 Ways to Enhance Tableau Dashboard Interactiveness using Set Actions

BI Connector Team |

Interactive Dashboard

Using Tableau Set Actions in Your Work

You may have previously used sets in Tableau to create a subset of your data or to group your data based on some predefined conditions. At the row level, individual records are either in or out of the set. There are two types of sets: fixed and dynamic. In fixed sets, changes in data do not affect the in/out condition of your set. When you select a dimension and use Create > Set, you are essentially creating a fixed set. In a dynamic set, when the data changes, the set may change based on whatever conditions or calculations affect the set.

[Tableau Hacks] How to Save Dashboard Space With Hidden Containers? >>

In this article, we are going to look at examples of set actions in Tableau and discover ways of using this feature to improve interactivity on our everyday Tableau dashboards.

What are Set Actions

Set actions are a feature in Tableau that provide Tableau users more control over interactivity in their dashboard design. This control over interactivity makes it easy to coordinate different actions across multiple views with a single click or selection.

Using Sets to Show a Part to a Whole Relationship

One useful way to use Set Actions is to show a part to whole relationship.  If we want to see how a specific Region contributes to Sales in our various Product Sub-Categories, we can use set actions to highlight the contribution.

Steps:

  1. In Tableau, connect to the Superstore Sample data Source
  2. Drag the Region dimension to the Row Shelf and then Sales to Columns
    Region-wise-sales

[Whitepaper] Connecting Tableau to OBIEE Without Oracle ODBC Driver >>

  • In a second sheet, bring your Product Sub-categories to the Rows and Sales to Columns
    Sales-by-product-sub-categories
  • Create a set using the Region Dimension by right-clicking the Region dimension and selecting Create Set. Name it the Region Set
    Creating-a-Set-in-Tableau
  • In the set pop-up window select any of the Region values and select OK.
    Region-selection
  • In the view that shows Sales by Product Sub-category, drag the Region set to color
    Drag-region-set-to-color
  • Tableau Row Level Security (RLS) Setup – Simplified Guide >>

  • Now create a dashboard and drag both charts into it
    Drag-reports-to-Tableau-Dashboard
  • From your dashboard view, select Dashboard > Actions
    Select-Actions-from-Tableau-Dashboard-view
  • In the pop-up window select Add Action > Change Set Values
    Change-set-values
  • 5 Quick Ways to Export Data From Tableau to Excel >>

  • In the pop-up window, set the options as you see in the screenshot below
    Set-options
  • Hit Ok. You can now test the Set Actions by clicking on the Region bars on your dashboard.
  • Using Set actions to swap sheets

    Sheet swapping is a useful way to save space on your dashboard. This method of cycling through sheets view can be achieved using a parameter. However, if you are thinking of a more dynamic approach, you can use Set Actions. In the example below we’re going to use the various Segments (i.e. Consumer, Corporate & Home Office) to cycle between various charts.

    Tableau Certified Connector for OBIEE, OAC & OAS – Try it Now >>

    Steps:

    1. Build a chart that shows the overall Sales segmented by product Sub-Categories. Name this chart as Consumer Sub-Category
      Sub-category-sales
    2. Build a second chart that shows a map of Sales. Name this Corporate Map
      Corporate-Map
    3. Create a third view that shows the trend of sales based on the month of the year. Name this chart Home Office Trend
      Monthly-Sales

    How to Use Graph Analytics for Big Data? >>

  • Right-click on the Segment field and create a set. Select any value within the set. Name the set and select OK.
    Creating-set-in-Tableau
  • Create the calculation below to determine which Segment is displayed when a Set value is chosen
    Calculation
  • Create another calculation just as the screenshot below to enable the sheets to be swapped when a value in the set is selected
    Calculation
  • Tableau vs OBIEE – H2H Comparison [eBook] >>

  • Next build a view that would serve as a selector for the various charts we built as shown in
    Building-view-in-Tableau
  • Create a dashboard and drag the selector sheet to it. Place an empty vertical container next to the selector sheet as shown below
    Empty-vertical-container
  • Open the Dashboard actions menu and select Change Set Values
    Change-set-values
  • [Open Secret] How to Securely Connect Tableau to OBIEE and OAC? >>

  • Select the options as shown in the screenshot below
    Select-options
  • Click on Consumer in the selector sheet. Now go to the chart Consumer Subcategory.
  • Drag the Sheet Swapper field we created earlier to the filter shelf and ensure the correct filter is selected
  • 5 Stages of Data Analytics >>

  • Repeat step 11 & 12 for Corporate and Home Office. Always ensure you click on them in the Sheet selector first.
  • Now drag the sheets Consumer Subcategory, Corporate Map and Home Office individually to the vertical container on the dashboard and each case hide the title
  • Now click through the options on your sheet selector to ensure the views are being swapped
    Checking-the-swaps
  • Using Set Actions to Drill Down

    When working with views that involve a hierarchy or several levels of detail, you can use Set Actions to achieve. In the tutorial below, we will build a hierarchy involving Category, Sub-Category and Product Name.

    Steps:

    1. Create a hierarchy using Segment, Category and Sub-Category
      Creating-hierarchy-in-Tableau
    2. Right-click the Segment field and create a set. Leave the values empty
      Creating-set

    5 Must-haves of Tableau OBIEE/OAC/OAS Connectors >>

  • Name the set Segment Set
  • Open the calculation window and input the formula below. Name it First Level and hit OK
    Calculation
  • Right-click the First Level field from your data pane and create a set. Name it First Level. Leave the values empty
  • Open the calculation window and input the formula below. Name it Second Level and hit OK
    Calculation
  • Drag Segment and the First Level and Second Level calculations to Rows and Sales to the Columns shelf
  • Name the Sheet Drill Down
    Drill-down-sheet
  • Create a new dashboard and drag the Drill Down Sheet to it
  • Select Dashboard Actions and Select Change Set Values and configure the action as shown below for the first hierarchy
    Configuring-action-for-hierarchy
  • Repeat the process for a second hierarchy as shown below
    Hierarchy-Tableau
  • Test interactivity by clicking through the Segment, First Level and Second Level on the dashboard
    Drill-down-using-set-actions-in-Tableau
  • Subscribe to BI Connector blog to learn more on Tableau tips and tricks. Want to visualize OBIEE data in Tableau? Try BI Connector for Tableau free!