Robyn, I've done some analysis on this. I think the difference is because of the filters on the Traffic to Views tab of that Dashboard. When I look at a Workbook created this year - the numbers match. When I switch to an older Workbook the numbers don't. This is while I am filtering on Current Year (and min View Count is 0).
In short the numbers match but not for the filters you are using?
I've compiled a list of Postgres Joins you may find useful in the future for these types of questions or if you want to write more of your own custom queries:
Thanks Luke for taking the time to answer my question!
I'm not sure I understand what you mean about the filters I am using. Do you mean the year Time Range filter? I noted that I used "all years" (we only had Tableau for around 2.5 years?) (see screenshot below).
Shouldn't the view count account for all years if the time/date range includes all the years we have had Tableau? Or are you saying it will only be correct for the current year only.
I also used the Tables in the PostgreSQL database to construct custom views and was able to replicate the numbers that Tableau gave in it's prebuilt Administrator "Traffic to Views" and view_stats table. (screenshot below).
Note that "Views" = traffic to views (historical tables) and "Looks" = nViews from view_stats table. I got that "Looks" terminology from the forums... I forget where. But the years for both are wide open.
I think I might be missing something here. Perhaps updating views or adding more sheets to views affects the counts? ---I'm trying to test all of that with my "Compare Views and Looks" dashboard on a NEW clean workbook (see screenshot below).
But the numbers always come up the same no matter how I enter the views, activate tabs and enter tabbed views, etc.
I really appreciate your help with this Luke! I'll try to hunt down and test some of those table joins in your SQL query and see if they produce different results. It looks like you're using the same tables, but perhaps the joins differ. I'll let you know if I find anything exciting!
1 of 1 people found this helpful
The historical_tables has a 6-month retention by default (see parameter wgserver.audit_history_expiration_days in tabadmin set page tabadmin set options).
The nviews corresponds to the lifetime cumulative value of the views (i.e. from first publish).
This might explain your differences.
Perfect! Thanks Damien!!!