Filter actions send information between worksheets. Typically, a filter action sends information from a selected mark to another sheet showing related information. Behind the scenes, filter actions send data values from the relevant source fields as filters to the target sheet.
The first action will filter the customer sheet per Subcategory, measure selected and hide the customer sheet when nothing is selected. The second action will keep only the selected sub-category (filter source sheet) subcategories – subcategories (select and show all values).
We can use this method in order to save more space in our dashboard.
→ In Tableau Desktop, connect to Global Superstore data provided by Tableau.
→ Create a sheet with SUM(Sales) and SUM(Sales) on columns and Sub-Category on rows. Add each measure on each card on color and label.
→ Create a sheet with Measure Names on columns and Customer Name on rows. Bring the Measure Names on filter and keep only Profit and Sales. Add Measure Values on Label and Color. Choose from the Mark: Square.
→ Ensure that each worksheet is on ‘Fit Width’ mode.
→ Add the first filter action:
Dashboard actions → Source Sheets: Subcategory (Dashboard) → Run Action on Select → Target Sheets: Customer (Dashboard) → Clearing the selection will: Exclude all values
→ Add the second filter action:
Dashboard actions → Source Sheets: Subcategory (Dashboard) → Run Action on: Select → Target Sheets: Subcategory (Sheet) → Clearing the selection will: Show all values.
Watch the video tutorial here:
About btProvider:
We hold all possible technical and sales certifications for all products:
Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, and Tableau Data Management.
With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will take smart and strategic decisions and you will quickly understand the data flow, numbers and the results it produces. See other #skillpill video tutorials here:
How to display multiple insights on a dashboard in #Tableau
How to create Stacked Bars on Grand Totals in Tableau
How to create a Buffer Zoom in a Tableau Map
Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company?
See how Tableau works, by downloading a free trial here:
How to Retrieve and Process JSON Data from a REST API in Talend Are you working as a Data Engineer, and have you started using Talend? Maybe in one of your projects, you need to retrieve data from a REST […]
💡 Unlock the Power of Tableau for Smarter Data Decisions Are you ready to transform the way you see and use data? Tableau is more than just a data visualisation tool, it’s your gateway to interactive, intuitive, and impactful business […]
You are working at a Data Analytics company, and in one of your projects, you need to load data from a source into a target table using Talend. However, while running the Talend Job, the data will fail to load […]