How to See Who Has Viewed a Tableau Dashboard
Knowing who uses your Tableau dashboards - and how often - isn't about vanity metrics, it's about understanding impact. You spend hours building insightful reports, and tracking viewership helps you see what's resonating, what's being ignored, and how people are engaging with your data. This article will show you exactly how to see who has viewed your dashboards using Tableau’s built-in tools.
Why Bother Tracking Dashboard Views?
Before jumping into the "how," it's worth understanding the "why." Tracking dashboard usage provides direct feedback on your work and helps you make better decisions about where to invest your analytical resources. Here's what you gain:
- Measure Adoption and Engagement: Are people actually using the dashboards you create? High viewership indicates the dashboard is valuable, while low viewership might mean it's not useful, hard to find, or your audience isn’t aware it exists.
- Identify Critical Reports: You can quickly see which dashboards are mission-critical (viewed daily by leadership) versus those that are niche or used infrequently. This helps you prioritize maintenance and updates.
- Optimize and Improve: If a dashboard has tons of views, it's a clear winner. If another one is being ignored, you know it might be time to gather feedback, simplify the design, or retire it completely to reduce clutter.
- Justify BI Investments: Demonstrating that dashboards are actively used by dozens or hundreds of team members is a powerful way to show the return on investment for your company's Tableau licenses and development time. It turns data from a cost center into a proven asset.
Method 1: Using Tableau's Pre-Built Admin Views
If you have Tableau Server or Tableau Cloud (formerly Tableau Online) and admin or site administrator permissions, this is the easiest way to get started. Tableau includes a set of pre-built administrative reports that provide high-level insights into site usage, including dashboard traffic.
The key report here is called "Traffic to Views." It’s designed to answer questions like, "Which views are most popular?" and "Who is looking at these views?"
Step-by-Step Guide to Accessing Admin Views:
- Navigate to your Tableau Server or Tableau Cloud site.
- On the left-hand navigation pane, click on Site Status.
- You’ll land on the Admin Views dashboard section. Select the report titled "Traffic to Views". If it's not immediately visible, look under the Performance or Traffic sections.
- This will open a pre-built Tableau dashboard. At the top, you'll see several filters you can use to drill down:
The dashboard itself visualizes the total number of views over time and provides a list of specific users who have accessed the views. You can now see every user who has looked at a dashboard within your selected timeframe and how many times they viewed it.
Pros and Cons of This Method:
- Pros: It’s incredibly fast and requires zero setup. If you're an admin, you can get answers in less than a minute.
- Cons: This is only available to administrators. You can't grant access to project leaders or non-admin users. The data is also aggregated and offers limited flexibility if you want to ask more complex questions.
Method 2: Building Your Own Usage Dashboard with the PostgreSQL Repository
For a more powerful, flexible, and customized way to track viewership, you can connect directly to the Tableau Server Repository. This is a PostgreSQL database that Tableau uses to store all its metadata - information about users, projects, workbooks, data sources, and user activity.
By connecting to this repository as a data source in Tableau Desktop, you can build your own bespoke usage dashboards that can be shared with non-admin users. This approach gives you complete control over the analysis.
Step 1: Enable External Access to the PostgreSQL Database
By default, you can't access this database from outside the server for security reasons. A server admin needs to enable it first and create a read-only user password.
The admin will need to open the Command Prompt (or Terminal on Linux) on the computer running Tableau Server and run the following TSM commands:
tsm data-access repository-access enable --repository-username readonly --repository-password YOUR_SECURE_PASSWORD
tsm pending-changes applyMake sure to replace YOUR_SECURE_PASSWORD with a strong, secure password. This command creates a user named readonly that has permission to query (but not change) the database tables. Keep this password safe - you'll need it in the next step.
Step 2: Connect Tableau Desktop to the Repository
Now, open Tableau Desktop and connect to this newly accessible data source.
- On the start screen, under "To a Server," select PostgreSQL.
- A connection dialog box will appear. Fill it out with the following information:
- You may also need to check the "Require SSL" box, depending on your server's configuration.
- Click Sign In.
If the connection is successful, you'll see a list of tables and views from the repository in the data source pane.
Step 3: Build Your Custom Viewership Report
You're now connected and ready to build. The sheer number of tables can be intimidating, but you only need a few to track who viewed what dashboard.
The most important tables for this task are:
- public.historical_events: This is the golden table. It's a log of significant actions, including who did what and when.
- public.historical_event_types: This table defines what each event type in the log means (e.g., 'View Viz', 'Login', 'Publish Workbook').
- public.hist_users: A table with information on your users.
- public.hist_views: A table containing metadata on every view and dashboard.
Creating the Data Model:
Start by dragging historical_events onto the canvas. It will be your central table. Then, create the following inner joins:
- Join
historical_eventswithhistorical_event_typesusing the common fieldhistorical_event_type_id. - Join
historical_eventswithhist_usersonhist_actor_user_id = id. - Join
historical_eventswithhist_viewsonhist_target_view_id = id.
This structure connects user actions to specific users and the views they interacted with.
Building the Worksheet:
Now, head to Sheet 1 to start building your actual report.
- To limit the data to only dashboard views, find the field "Name" from the
historical_event_typestable and add it as a filter. Select the value "Access View". - Drag the "Name" field from the
hist_userstable to the Rows shelf. This will list all users who have viewed something. - Drag the "Name" field from the
hist_viewstable to the Rows shelf, right after the user name. This will show which specific dashboards they viewed. - To see when they viewed it, drag "Created At" from the
historical_eventstable to the right-most position on the Rows shelf. Right-click it and choose "Exact Date" and then "Discrete" to see the full timestamp for each view. - To get a count, you can simply drag "Number of Records" to the Text card on the Marks shelf.
What you have now is a detailed, row-level log of every single dashboard view. You can pivot this data any way you like - create charts showing views over time, top 10 most viewed dashboards, or top 10 most active users. Once you're done, you can publish this as a new dashboard to Tableau Server and share it with managers or project leaders who don't have admin rights!
Final Thoughts
To recap, you have two primary methods for tracking dashboard viewership in Tableau. The built-in Admin Views are perfect for quick, high-level summaries if you have site administrator privileges. For deeper, more flexible, and shareable reports, connecting to the PostgreSQL repository allows you to build completely custom usage dashboards tailored to your exact needs.
We’ve seen firsthand how crucial it is to make data accessible and easy to understand without needing a technical background. While building custom administration reports is a great way to monitor usage, the core challenge is often creating impactful reports in the first place - a process that can be slow and complex. With Graphed, we streamline the entire analytics workflow. You can connect all your sales and marketing data in seconds and build real-time dashboards simply by describing what you want in plain English, empowering your whole team to get answers in moments, not hours.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.