CODEWITHSUNDEEP
filteractiondashboardtableau-api
Rhonda
Rhonda

Reputation: 1721

Tableau dashboard action unresponsive

Workbook is on Public Tableau

I'm using one drop-down, which is a calculated value (refer previous question) to control map, and two worksheets.

When I toggle through the filter, only the relevant location appears on map, while the other two worsheets do not change, i.e. they show all locations.

enter image description here

How to fix this?

Thanks once again!

Upvotes: 0

Views: 1992

Answers (2)

kaz
kaz

Reputation: 134

To get tableau Action revealed on another data.

Step1

Go to Dashboard > Click on icon dashboard > Click on Action > Select Add Action > Filter and follow further steps as per given as

enter image description here

Step2

Click ok in action and you will get desired results

Step3

In your Dashboard Filter which is

enter image description here

select the icon and follow steps further which is describe below :

enter image description here

This will get desired results as per your requirement.

Result: your result will look like this example as given as

enter image description here

Upvotes: 2

Andrew LaPrise
Andrew LaPrise

Reputation: 3413

You can't filter multiple worksheets with a table calculation (your intuition about why is exactly right). BUT we can do something sneaky again.

First, create a parameter to replace your quick filter. Let's call it "Choose Location". Make the data type "String", then select "List" from Allowable Values. Go to "Add from Field" and select "Location (Loc)". Your parameter will now allow you to select from a list of all the different values of [Location (Loc)].

Since you want to be able to show all of the locations at once, also add "All Locations" to the parameter's list of allowable values (I put it at the top of the list because that's what my heart said to do).

Next, create a calculated field. Let's call it "Choose Location Filter".

IIF([Choose Location] = "All Locations", TRUE, [Choose Location] = [Location Filter])

This statement will return TRUE if the Location on the given row of the partition is equal to the Location selected in the parameter and FALSE otherwise. If you've selected "Multiple Locations", it will return TRUE for all rows. Note that we're still using the [Location Filter] that you made so that we can maintain all locations in our partition and calculate that Grade.

Now, in every worksheet, replace the [Location Filter] in your filter card with the [Choose Location Filter] field. Filter out the FALSEs, leaving only the TRUEs. Place the parameter control on your dashboard and use that to filter instead of the quick filter you built previously.

Upvotes: 1

Related Questions