8 Replies Latest reply on Jan 18, 2018 8:00 AM by Matt Coles

Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Ashish Vij Jan 9, 2018 7:49 AM

Hello All,

I have created a dashboard which Has the Table containing:

Fields:-View Name,UserName,View Count.

Requirement: I want to fetch view count for a particular time period,Say last month.

The Challenge is We don't have Date Dimension for the views in Repository, from where we can fetch it for a particular time period.

There is one Dimension 'Time', which is displaying False information. It is giving for the whole period of time and not particular period.

Steps Tried:I made a calculated field with Today() Function(for Testing), that also doesn't display correct information

Please provide some pointers on how to fetch for particular time period say(Last Month's View count for views)

P.S:Using Repository as the data source.

Appreciate your help !

Thanks

Ashish Vij

1. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

lenaic.ridinger Jan 16, 2018 5:40 AM (in response to Ashish Vij)

hi Ashish,

Fetching view count for a date when you don't have date is indeed quite a challenge.
Could you please share your workbook so I can investigate this?
Cheers

----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Like Show 0 Likes(0)

Actions
2. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Toby Erkson Jan 16, 2018 9:05 AM (in response to Ashish Vij)

I'm pretty sure the internal db does not log the date stamp of every individual view in a historical or archive sense, it only logs the last recent view. However, the info may be available in the http history table or by parsing the log files (yuck).
Like Show 1 Likes(1)

Actions
3. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Matt Coles Jan 16, 2018 9:31 AM (in response to Ashish Vij)

By "view" do you mean "sheet of a Tableau workbook"? Or do you mean "the action of a user who opens a sheet of a Tableau workbook on Tableau Server"? If you're talking to the Repository database, what tables are you using to get this info?
Like Show 1 Likes(1)

Actions
4. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Toby Erkson Jan 16, 2018 9:37 AM (in response to Matt Coles)

Matt Coles wrote:

By "view" do you mean "sheet of a Tableau workbook"? Or do you mean "the action of a user who opens a sheet of a Tableau workbook on Tableau Server"? If you're talking to the Repository database, what tables are you using to get this info?
Side comment: I really dislike the fact that Tableau uses "View" instead of "Sheet". It's highly ambiguous for Tableau admins!
Like Show 0 Likes(0)

Actions
5. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Ashish Vij Jan 18, 2018 1:20 AM (in response to Matt Coles)

Yes Matt By View i mean sheet.In repository we'll get the name of sheet as view only,as given by tableau.Thanks !
Like Show 0 Likes(0)

Actions
6. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Ashish Vij Jan 18, 2018 1:23 AM (in response to Toby Erkson)

Yes toby it displays only Last Viewed time stamp.
We were thinking of checking the view count for every view for a particular time period ,but we din't get any respective filter or field with respect to that.
I'll try parsing the logs method.
Any other method,do let me know.Appreciate your help.Thanks !

~
Ashish
Like Show 0 Likes(0)

Actions
7. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Ashish Vij Jan 18, 2018 1:33 AM (in response to lenaic.ridinger)

Hi Lenaic,

Thanks for the feedback.I might not be able to share the workbook because of client restrictions.
Please use data from repository.We need to get View count for each view for particular time period(say 1 month,1 week,etc)
You can use the Workbook field,Views Field from repository.We are unable to find time field.
Let me know if you could find an alternative.

Thanks
Like Show 0 Likes(0)

Actions
8. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)

Matt Coles Jan 18, 2018 8:00 AM (in response to Ashish Vij)

You can obtain this information from the historical_events table in the postgresql repository database. I have a curated data source based on that table that you can start with called TS Events, downloadable here. Use the filter Event Name = Access View. The Event Date fields will contain the date and time that the access event occurred. The Item Name will be the name of the view. If you want the Workbook name as well, use Item Root Repository URL. (Technically that will not be the name of the workbook, but will instead be the URL-name for the workbook, which removes spaces and special characters and things).

Hopefully that gets you what you need.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions

Go to original post