1 of 1 people found this helpful
Here is the basic URL pattern for passing filters:
so for example, if a workbook named CoffeeSales has a view named SalesPerformance, and you want to limit the view to Market=West, you would pass:
If you wanted to also limit the view to Market=West or South:
If you want to pass filters on two fields, you might have:
Note the URL encoding on the Product Type field.
All this is from the excellent document "Tableau Server URL Parameterization and Limits", which you can probably get from Tableau Support, or click or the link below:
Peace and All Good!
Michael W Cristiani
I try Tableau WOW workbook Example9 sample and it did not work for me
It still shows all region.
still shows all years.
has no effect, view shows all data.
We still on version 4.1.
What I am doing wrong?
Be sure the capitalization of field names and values are exact. For example, is it "region" or "Region", and "east" or "East"? Also, in your example, is their a field called "year or "Year", or is this the year DATEPART of a datetime field in the datasource. If the latter, and the data includes time, the value is likely stored by Tableau as something like, "2007-07-01 00:00:00", using a 24 hour clock for the time part. In this case, specify the filter using FieldName=2007-07-01%2000%3A00%3A00, where the %20 encodes the space, and the %3A encodes the colon (:) that is part of the time part. Not sure, myself, how to specify just the year for a datetime field. Maybe a Tableauian monitoring this forum can add some more info?
If the URL parameterization does not work, the results you are getting are correct -- they are just ignored.
Please make these changes, Please post your results.
Peace and All Good!
I think I found what was wrong.
If you first open view from the server view lists like this
and then changed to (type at the end)
and click Go (I am using IE 6) 2 things happened:
1.Region became region and East become east
2 View does not got filtered.
If I open brand new browser and paste
Do you think it can be a bug?
Sounds like IE6 is auto-completing your URL as you type, which is changing your capitalization.
Here is a twist on this topic. Regarding the field names in parameterization, are they the remote DB column names, or the current Tableau name of the field? For example, if a field on which the filter should be applied in the URL is named 'location_cd' in the remote db and in the Tableau data window, the following URL successfully filters the results to location_cd=25:
However, if the field name in the Tableau data window is changed to 'STORE NBR' by right clicking it and choosing Rename, will the above URL still work, or need it be changed to:
Right now, neither seems to work.
Any help would be great
It should work off of the alias (the name in the Tableau data window). It looks like your 2nd link should work, unless I'm missing something.
are range parameters possible? i tried using %3E for >, but I had no luck ...
Nope - at least not for categorical filters. You can only give sets/equality. I don't remember what the support is for quantitative filters in the URL...
Is it possible to use URL filtering in the above format to manipulate Web Page Objects on a dashboard?
I have a dashboard showing individual product information which includes a web page object displaying our company website page for that product.
I had hoped to link to a filtered version of the dashboard from another webpage by applying a filter on stock code using the URL filtering.
This works fine but does not update the web object which remains blank. I know i can add a separate action to update the web page object on select or on hover but would prefer it showed the entire dashboard from the second it is opened.
Hmm... as far as I know, Tableau doesn't provide a way for Actions or filters to trigger other Actions in that way. And web page objects don't respond to any URL parameters. Sorry.
First of all thanks for all usefull information.
I have scenario similar to the above topic and need some guidance.
I have view with list of different experiments performance as below -
I want to create a url on this field Exp # so that for each value i can open the view filtered for that Exp. So when click on Exp1 i see view with Exp 1 only similarly for Exp 2 / 3 ....
Is it possible ????
This should also allow any new value in the experiment list automatically have a url for it. So say initially i have only 10 Exp's but next day i have 11th Exp. I should be able to have a url for EXP 11 as well automatically.
I was able to implement the solution by using a Action URL as per details in your comments earlier in the discussion.
Is there a link or doc which explains more details on the URL in Tableau apart from the ppt.
I am looking for option for opening in new window, so that i can open multuple Exp's in seperate windows my self