I think you should be passing an actual value (manager's name) to the field in your URL filter, e.g:
another way of doing it is to create a calculated field that will check if
and return True or False. You can then use something like
How would I pass the manager's name? In the case above, the manager is the person viewing the report. Smith has a userid of AAA1 that he uses to access Active Directory (and Tableau) and his name is "Smith". I want to use the user function FullNameI() to pass that variable.
I don't think you can access user functions from URL.
But have you tried User Filters, as described here:
It will require storing AD user names with your data (could be a separate data source in Excel etc., but then you'll have to do a data blend) and will filter the view, i.e. hide other managers' content from this user, but it might work for you.
I've tried that. and that works if you need to use a user filter to set security as in Project Manager Smith can only see his projects.
But I just want a default. So when PM Smith comes in, he see's his projects, but he can also change the quick filter to see his co-workers projects.
As Dimitri said I don't think you can get there from here exactly the way you want to.
The easiest way to approach this is just to tell people to filter their report the way they want it (by Project Manager) and then use the "Remember my Changes" feature. They could save multiple versions filtered different ways ("me only", "everyone", "people who like star trek", whatever).
If you really want to try and completely automate this, I've attached a sample that more-or-less does what you want without passing anything into the report.
"Name" is my equivalent of your "Project Manager" and is used as the quick filter.
I use a parameter ("Show Me or All") and another calculation named "Filter the Filter" along with "Show Only Relevant Values" of the "Name" quick filter to show/hide project manager names in the quick filter itself. You essentially can toggle between "show only my name" in the quick filter and "show everybody".
It's certainly is a hack, and I think the first approach I mentioned is smarter/cleaner, but there you go
You'll need to replace a "Name" value in the attached worksheet with your user identity to test...I was simple\russch, replace with your domain credentials or whatever is returned by fullname() for you.