I need to get 10.0 installed ...Pop out a sheet with "Admin Panel" if ISUSERNAME is you. Make the pop-out control sheet act on ISUSERNAME. If it's anyone else, the pop-out sheet goes away, and that will hide the "Admin Panel" sheet.
And just put your action on the "Admin Panel" sheet. Other users won't see it to click it if they are not you.
Slow down Kemosabe, my horse isn't as fast as yours.
I think I understood part of what you said but ended up with a single row data table displaying - or not - during testing. Wasn't as slick as my example picture So I don't quite understand. My Desktop kung-fu is green belt You're more in the darker colors than I
You can use an earlier version of the sample workbooks, that's all I attached except I removed some of the dashboards and worksheets to slim it down.
Ah. I thought your example had all the trucks on it and all.
In dashboard1 I made a container that uses the fabled popping technique. The popout sheet has a filter that uses ISMEMBEROF because I can remember what group I am in, but I really don't know my exact Tableau username... But we have functions that will let you see what the user's GROUP is, or USERNAME, or FULLNAME and maybe some others.
Modify that calc so that it either looks for whatever GROUP you are in, or change it to ISUSERNAME and put in your username.
(For testing purposes I added in a simple check for a parameter value just so you can see how the popout container functions without having to change your username from test to test.)
Then go to Dashboard 1. Mess around with "Bogus Parameter". You'll see that the Popout sheet comes and goes based on that value. And when the popout sheet displays, it pushes the Admin sheet down.
Now go to Dashboard 2. I have re-positioned the container so that its starting y-coordinate is in negative space. When the parameter is 1, it pushes the Admin sheet into the dashboard view.
You can kill the bogus parameter and just do the same with the ISMEMBEROF/ISUSERNAME function. If the user is not you, the popout sheet will collapse and hide the admin sheet.
superstore -- pop out admin.twbx 1,011.8 KB
Joe, the video helped. I used the popping technique after watching it and then used an URL Action to to jump to another single-sheet workbook that has the view I want to work with. I couldn't figure out how to jump to another sheet within my workbook
Floating worksheet "Admin Panel" on dashboard:
Yes, the floating pane is almost 1/2 way off the dashboard This allows the colored backgrounds to mesh, no borders to display, etc. I like this "off-sheet" ability.
How it looks when I'm logged in:
When someone else is logged in:
The URL Action in the dashboard for clicking on the "Admin Panel" goes to the other report:
My "Admin Panel" sheet (which is hidden):
...and the calculation:
Thank you for the help
1 of 1 people found this helpful
Create a new action. Select FILTER, even though you are not really filtering anything. Do a SELECT action. In that dialog box you specify the source dashboard (where you are -- just like your screen shot above) and your destination dashboard. (Or maybe it's called target...) In that pulldown you can specify a sheet or a dashboard or a data source. I always choose a dashboard. And then any sheet on that dashboard (or all, it really doesn't matter.)
Next in that box is a section for "Target Filters". Click "Selected field", but then you don't specify any field, even though it asks you for one. Just click OK. You'll have a filter action to another dashboard without specifying anything to filter.
Let me know how it goes.
Of course, this only works from/to dashboards within the same workbook.
1 of 1 people found this helpful
BTW, Toby. It looks like you have positioned the Admin View sheet in that specific location, and are counting on the sheet to display or not depending on whether it had the right user. In most cases that's OK, and it looks like that's the case for you. There is no underlying sheet that a user might want to click on.
When a sheet is placed in this way, even when no data is in it, the sheet still occupies that space on the dashboard, and when there is a need to have an underlying sheet, only the topmost sheet in the floating order will have cursor access. (Sometimes people try positioning multiple sheets in the same location, and only one will display, but regardless of which one is displayed, only the one at the top of the floating order will get tooltips, highlighting, etc.)
The more complete way to handle that is the popping method I gave in the sample workbook earlier. A "pusher" sheet displays or disappears based on the popping condition, and the actual sheet you want to see gets pushed into view when appropriate. All that happens inside a container. And when the actual sheet disappears, the space it occupies also moves, and the cursor DOES reach through the container and gets to the underlying sheet(s).
But for what you are looking to do, what you showed in the screenshots looks great.
Ah, gotcha, good point! Thanks Joe