2 Replies Latest reply on Feb 11, 2019 11:50 AM by Samuel Yates

    Filtering historical_events based on workbook permission level

    Samuel Yates

      Hello everyone,


      I'm having some issues filtering my dashboard and I was wondering if anyone might have some answers. Here's the story so far:


      Trying to recreate a user accessible version of the traffic to views screen from the tableau admin tools. Done, works great.

      I only want to show users traffic stats for workbooks that they own. So I set up RLS where username()=workbook_owner.  Done, works great.


      I'm feeling super cool at this point, then my colleague suggests that it would be great if I could show stats to anyone with publish permissions in order to eliminate a key person dependency.  Now I'm stuck.


      I have done the postgres to get historical events. And I have done the postgres to get a list of project/workbook/user/capabilities thanks to scouring this forum.


      How would you combine these to filter that dashboard view? I can't find any reasonable way to join them together without everything exploding.

        • 1. Re: Filtering historical_events based on workbook permission level
          Joe Oppelt

          We place users into groups on the server.  (Users can be in multiple groups, BTW.)


          I have sheets and buttons and other objects on dashboards that only certain users can see.  For instance we might have a group called "Finance".  Anyone in the "Finance" group can see a particular sheet.  But I expose filters for that sheet only to certain users.  These users I have put into a second group called "Power_Finance_Users".  And I control display of the filters with a calc that says:


          IF ISMEMBEROF("Power_Finance_Users") then 1 else 0 END


          I do this for Power_Broadcast_Users and Power_Pledge_Users as well.  It has worked out very nicely for me.


          Specific to your question, you could put people with publish permission into a special group, and then prevent everyone else's access to stuff only the publishers should see.

          • 2. Re: Filtering historical_events based on workbook permission level
            Samuel Yates

            Thanks Joe, that's helpful. I should be a little more specific I'm trying to filter workbooks to only display themselves to users with publish rights to that particular workbook or even project.


            I think if I understand you correctly, I'd be making a group for each workbook of users who can publish it. If there's a way to automate that, then I guess I could go for it. But otherwise, I'm not sure that would work.