5 Replies Latest reply on Dec 9, 2016 9:18 AM by Toby Erkson

Tableau Views statistics using _ViewStats and the admin view

aqua.lover Nov 21, 2016 5:01 AM

Dear all,

Currently I am using the Admin view (Traffic to views) to see which of our workbooks/views are being seen the most.

However to see these stats I need Admin access. Today we have many people who would be interested in seeing these statistics. Of course for security reasons, we cannot make them all admins.

As such, what I am doing is creating an extract from the Tableau server stats and then creating a Tableau Reports from this extract.

I am doing the following query:

However, when I compare the view counts for one view i see that the 'Traffic to views' shows me that the report was seen 487 times while my Tableau report using the above query shows me 754 views.

I'm not sure what is causing this difference.

I'm not sure how the 'Traffic to views' work as sometimes it shows me 2 lines for the same 'View' and I don't see the difference (I'm guessing it is a version question?).

As a FYI, I do not have access to the Tableau server database (I depend on someone from our company team to do the extract for me) so unfortunately I'm a bit blind and can't really test live...

Thanks a lot in advance for your help

Cheers

1. Re: Tableau Views statistics using _ViewStats and the admin view

Patrick A Van Der Hyde Dec 1, 2016 4:03 PM (in response to aqua.lover)

I have moved this question to the Server Administration area of the forums. There are several resources related to custom admin views of Tableau Server data that can be found linked here:: Tableau Server Resources in the Monitoring and Management section.

And here are several workbooks showing Tableau Server views in workbooks that have already been configured and documented:
Tableau Workbook Library

I hope that helps.

Patrick
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Tableau Views statistics using _ViewStats and the admin view

Toby Erkson Dec 1, 2016 7:43 PM (in response to aqua.lover)

The workbook I posted here is the tabbed admin views:
Re: Tableau Server Activity
I have the workbook saved in my Admin project so end users can't see it (via permissions). I then put the Email Link of the report onto our Tableau administration SharePoint site to display the tabbed admin reports for everyone in the admin permission group to see (bottom-most viz)

Job: Done!
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Tableau Views statistics using _ViewStats and the admin view

aqua.lover Dec 9, 2016 7:34 AM (in response to Toby Erkson)

Hi Toby, Thank you very much! This helps a lot. I was given all the admin views as extracts so I can play with them.

Quick question, I am currently showing the stats using the Audit Table.

However the audit table shows me all data even for deleted workbooks. I would like to be able to 'point' which workbooks / worksheets were deleted .

To do this I would like to create some sort of calculated field that says: for each workbook, if there is an Action event that is 'Deleted Worbook' then Workbook status = 'deleted' else 'active'.
Same for the views: for each view, if there is an action event that is 'deleted sheet' then worksheet status = deleted' else active.

Is there a way to do this? I can only use the Audit Table and the filters.

Thanks a lot!

Cheers
Like Show 0 Likes(0)

Actions
4. Re: Tableau Views statistics using _ViewStats and the admin view

aqua.lover Dec 9, 2016 7:34 AM (in response to Patrick A Van Der Hyde)

Dear Patrick,
Thank you for your answer. The links helped me a lot.

I have now another problem which I asked Toby below. But maybe you can also help me (I don't know if I should post another question simply on this though).

Again thank you for your help!

Cheers
Like Show 0 Likes(0)

Actions
5. Re: Tableau Views statistics using _ViewStats and the admin view

Toby Erkson Dec 9, 2016 9:18 AM (in response to aqua.lover)

Glad you could get your hands on them.

Regarding your question, please start a new topic and provide specifics (for example, I don't know what you mean by "Audit Tables").
Like Show 0 Likes(0)

Actions