Tableau server version: 2022.3
Postgres repository table views_stats is providing 4 rows when expected only 1. What could be the reason?
For a particular user, and a particular view, 4 rows are found. see below. There are 4 ids and 4 timestamps.
If 'Time' field is supposed to store only the LATEST timestamp for the visit by a particular user to a particular view, what could be the reason for 4 IDs and 4 timestamps?
tableau.github.io/tableau-data-dictionary/2022.3/data_dictionary.htm⌗public.views_stats_anchor
@Zahid Ansari
You forgot to include the final row in your table screenshot:
You're seeing four entries because that's how many different devices can view the content:
This allows some analysis for the most popular method the particular sheet is being viewed*. If you simply want the most recent timestamp then use the MAX() function.
*I wish Tableau used the word "sheet" instead of "view". Sheet is more specific and doesn't carry two different definitions e.g. Count of views...is that a count of sheets or the number of times a sheet has been looked at?
---------------------------------
*** Tableau Ambassador, OG, retired ***
Tableau Server & Software Admin, based in Portland, OR, USA (GMT-7/-8)
-If replying to me please use the @mention so I will get a Notification.
-Please provide an answer to your posts and/or select Best Answer on the post that gave you the answer in order to help others.
