tableau / community-tableau-server-insights

Community-built data sources for answering questions about Tableau Server
MIT License
129 stars 52 forks source link

Access View event count incorrect for Workbooks (TS Events) #67

Closed aglukasie closed 1 year ago

aglukasie commented 2 years ago

Hi, I have noticed that the Number of Events for Access View events is incorrect at Workbook level. Access Views on existing Views are excluded from Access Views on Workbooks. This is incorrect, as view of a View also counts as a view of a Workbook.

Here's an example of Workbook no. 500. Access View

Workbook no. 500 was viewed 1402 times. But when I filter by Item type = Workbook, only 724 views are reported in the Number of Events column. That is because only Null views are included (ones that no longer exist, I presume). This is not correct. See the second column (Number of Events correct) to see what it should look like.

mcoles commented 1 year ago

Thanks for reporting. What's happening is here is that I'm using current state information to determine the Item Type for an event that is historically based. So in this specific case, if an Access View event occurred against a View that no longer exists, but the workbook still did (let's say the author deleted that particular sheet), the fallback logic in the Item Type calc would consider it a Workbook instead. For the purposes of the Item Hyperlink fields, this might actually have had some benefit, but on the whole it's a negative for accuracy. Should be fixed in the next version.

mcoles commented 1 year ago

This is resolved with the 04.01 release.