-
1. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
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!
-
2. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
Toby Erkson
Jan 16, 2018 9:05 AM
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).
-
3. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
Matt Coles
Jan 16, 2018 9:31 AM
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?
-
4. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
Toby Erkson
Jan 16, 2018 9:37 AM
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!
-
5. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
Yes Matt By View i mean sheet.In repository we'll get the name of sheet as view only,as given by tableau.Thanks !
-
6. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
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
-
7. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
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
-
8. Re: Unable to Fetch view counts For Particular Time Period(Days,Months,Quarter)
Matt Coles
Jan 18, 2018 8:00 AM
1 of 1 people found this helpfulYou 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.