You can add your filter and parameter values to the URL string.
I recently gave a detailed response to someone else about this in this thread:
In that thread the example I gave was just passing parameter values (which are always single-value entities). Grabbing the values of filters can get a bit more complicated. If you need to do that, we can discuss some ideas.
I did go through couple of threads before creating this one. I believe this case is bit different wherein I am using report(sheet1) in the dashboard as a filter for other reports contained in it. So I am not explicitly applying the filter, the sheet1 is the filter here.
Can you please help me with how I can utilize the values of filter in the url?
Do you think we can do this using the same approach as mentioned by you? I tried couple of things it did not work.
You can build a string of the selected dimensional values. It would be kind of specific to your sheet, but the logic goes something like this:
IF INDEX() = 1 then ATTR([dimension name])
PREVIOUS_VALUE(" ") + "," + ATTR([dimension name])
The stuff in the parentheses of the WINDOW_MAX is building a string of all the dimension values (of the specified dimension) on the sheet. The first part puts the first dimension value, and the second half keeps appending a comma and the next name.
(Note: If your dimension is a numeric field, wrap each reference to the dimension in the STR() function. You have to pass a string value in the URL.)
First play with that inner portion of the calc. Take a dummy sheet that simulates what you'll end up with on your dashboard and put that calc on the sheet. You'll see the calc "grow" as it works down the dimensions on the sheet.
The WINDOW_MAX will capture the ending value because that's what you really want.
So, as you can see, I said that grabbing the filter values is a bit more complicated. By the way, we aren't really grabbing the actual filter selections. We are grabbing the values that end up on the sheet. It's a technical distinction, and usually the end result is the same. But we don't have actual access to the filter structure. We only have access to the resulting data on the sheet.
Once you build this string, you plug that into URL string in the same way I demonstrated in the referenced link. There are some nice links out there that describe this method in more detail.
One final note: My hope is that your resulting URL string doesn't exceed some URL buffer limit. I recently saw a post on the forum with someone reporting that happening. I didn't see the resolution to it though. I have never blown a limit, so I haven't had to investigate this, and I don't know who sets the limit or what that limit is.
Thanks Joe for the this, I will try it out and let you know if this works in my case.
So this is what I am looking for, I want to use the action filters (in my case Date(worksheet) is one of the action filters). Is there a way where I can use it in the url?
I have filed a ticket with tableau support regarding the same. Will update once I have something from them.