How to calculate the time spent by a user on a specific page in an analysis in Spotfire

How to calculate the time spent by a user on a specific page in an analysis in Spotfire

Spotfire action logging, when enabled on the Spotfire Server, can help monitor the user actions and the time spent by the user on an analysis or a specific page via the Analyst or the WebPlayer

You can find more information on how to enable action logging at the below link
https://docs.tibco.com/pub/spotfire_server/10.10.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/enabling_action_logging_and_system_monitoring_using_the_command_line.html

 https://docs.tibco.com/pub/spotfire_server/7.11.2/doc/html/TIB_sfire_server_tsas_admin_help/GUID-6083CDAB-E023-4144-A65E-3559706FBA3A.html

This article describes a way to use the Action Logs to get the time spent on a page by a web user.

The Action logs database stores the information with the action "SET_PAGE"

When a user opens a particular tab in an analysis, action "set_page" is logged.

The below command can be run to get the 'set_page' result:

SELECT  *
  FROM [database name].[ACTIONLOG] where Log_action like 'set_page'

Example: SELECT  *
  FROM [spotfire_actionlog78].[dbo].[ACTIONLOG] where Log_action like 'set_page'
=====================================

In the above screenshot, you can check the user "Spotfire" has moved between pages "Example dashboard", "Marking", "Filtering" etc listed in the "ARG1" column for analysis "Introduction to Spotfire" and Session_ID "d7be0e...".  The time spent can be calculated by subtracting the Logged_time between 2 "set_page" Log_action  or between "set_page" and "close" Log_Action