-
1. Re: URL filter not working as expected
Chris McClellanOct 12, 2018 1:05 AM (in response to jens.bruckmann)
In the URL I think filter name and filter value are case sensitive, are you UsinG the Right CaSe ?
-
2. Re: URL filter not working as expected
jens.bruckmann Oct 12, 2018 1:09 AM (in response to Chris McClellan)Hi,
yes I checked it twice. the spelling is correct. I only have the filter value in brackets and I don´t know why
-
3. Re: URL filter not working as expected
Zach Leber Oct 12, 2018 8:02 AM (in response to jens.bruckmann)Your URL action in Tableau Desktop the URL should look like:
https://tableau-server.com/#/site/testingsite/views/testreport/Summary?filter%20name=<filter%20name>
You must enclose the field name in angle brackets to get the current value. Your current method is passing the string "filter value" which isn't even a valid choice so that's why it appears in parentheses in the target view.
-
4. Re: URL filter not working as expected
Chris McClellanOct 12, 2018 3:42 PM (in response to Zach Leber)
Ah, I hadn't even thought that you might be using a dashboard action to do this, I was simply thinking of a URL linked from somewhere
Maybe add a screenshot or 3 so we can see what's going on ?
-
5. Re: URL filter not working as expected
jens.bruckmann Oct 14, 2018 11:11 PM (in response to Chris McClellan)Good morning,
no I do not use a dashboard in this case. It is a simple worksheet where I try to filter via URL. I now tried to use <> within the filter but the output looks like the picture I have added.
this is the link
Still the brackets
-
filter.PNG 2.0 KB
-
-
6. Re: URL filter not working as expected
Chris McClellanOct 15, 2018 12:23 AM (in response to jens.bruckmann)
If you're just using a browser then don't use the < > brackets
I quickly looked at an old dashboard on my profile, I can do this :
or this https://public.tableau.com/profile/chris.mcclellan#!/vizhome/iPhone5Test/Dashboard1?Prices=Current
but I can't find any other quick examples
-
7. Re: URL filter not working as expected
Zach Leber Oct 15, 2018 6:10 AM (in response to jens.bruckmann)Please post an actual TWBX. Your example URL doesn't make sense. If you're trying to filter on Project Manager, your URL should be inserted into Tableau Desktop as https://tableau-Server.com/#/site/xxxxxx/views/ThisisthereportName/Worksheet?Project%20Manager=<Project%20Manager>.
The angle brackets tell Tableau you are inserting a field variable rather than a string literal.
Once you get that working, consider simplifying your URL to start with "/views" so it will always be relative to whichever site you've published to, no need for the full server and site name. If you're filtering from one view to another view in the same workbook you can further simplify the URL string to begin with the view name, e.g. Worksheet. Though in that case you might want to switch from a URL action to a Filter action.
-
8. Re: URL filter not working as expected
jens.bruckmann Oct 15, 2018 6:38 AM (in response to Zach Leber)Hi,
sorry I can´t provide the the used workbook for this as there are case sensitive information on it.
Nevertheless the link somply is the link I use when I open the document in tableau server. So I click the link ant the filter is in brackets then.
Sorry I do not understand why I need to add it to Tableau Desktop.
At the end I just want to create a report out of Tableau Server which I can send to different Projekt Managers via Email and have the Worksheet directly filter on their names.
-
9. Re: URL filter not working as expected
Zach Leber Oct 15, 2018 7:08 AM (in response to jens.bruckmann)Thank you for explaining that you are emailing links to your users rather than adding a URL action into a Tableau workbook. Try removing all brackets and escaping the embedded space in the names. You should be able to type Project Manager=Jens Bruckmann in your web browser and it will replace the spaces with %20 characters, e.g.
-
10. Re: URL filter not working as expected
jens.bruckmann Oct 15, 2018 11:15 PM (in response to Zach Leber)Thanks a lot for all your patience and to try to help me with this
I now removed everthying from the line including the %20 but it is still the same. In the filter, the name is in brackets but in the link there are no brackets. Any Idea would be helpful
-
11. Re: URL filter not working as expected
Chris McClellanOct 16, 2018 2:33 AM (in response to jens.bruckmann)
Can you create a new workbook and create some dummy data using exactly the same dimension name and dimension values please ?
It has to work, it does work, we just need to figure out why it doesn't work with your data.
-
12. Re: URL filter not working as expected
Bhrigu Aneja Mar 11, 2019 3:44 PM (in response to Zach Leber)Can you have more than one filter?
https://tableau.company.com/#/site/Security_Trust_Office/views/ShellforScorecard/PolicyBar?Implant Organization =<Implant Organization> Claim = <Claim>
-
13. Re: URL filter not working as expected
Bhrigu Aneja Mar 11, 2019 3:44 PM (in response to Zach Leber)https://tableau.company.com/#/site/Security_Trust_Office/views/ShellforScorecard/PolicyBar?Implant Organization =<Implant Organization> Claim = <Claim>
-
14. Re: URL filter not working as expected
Madeline Verette Dec 4, 2019 1:25 PM (in response to jens.bruckmann)Hello,
I found myself in a predicament exactly as Jens described and found a solution that (may) help others.
I had a URL such as the following: http://servername/views/CoffeeSales/SalesPerformance to which I had published a simple workbook displaying Sales and Budget. The only filters in my workbook were "Sales Office" and "Customer". Every time I tried to pass the Customer Filter in my URL, (i.e. /Customer=JOHNDOE), my report filtered to remove all data and leave "(JOHNDOE)" in the filter selection in my dashboard. Yet, I could easily search "JOHNDOE" in the filter manually to find it a valid selection.
The solution? I downloaded the workbook (formerly created by someone else) and discovered that "Customer" was a calculated field. While it shouldn't be problematic to pass a calculated field as a filter in the URL, the nature of how this field was calculated (including removing the Customer ID from the original field) left a space at the beginning of each customer name. As such, had I wanted to pass "JOHNDOE" in my URL filter, I would've had to do so as follows: /Customer=%20JOHNDOE to account for the leading space. To mitigate this, my best option was to redesign the Customer field calculation to remove the leading space. I am now able to pass a Customer filter exactly as first intended with /Customer=JOHNDOE and I yield the expected results.
*Note, renaming a field should not have an impact on passing it as a filter. I.E. if the original field was "Consumer" and was renamed to "Customer", the renamed "Customer" may still be used as a filter in the URL.
Hope this helps!