How to calculate the time spent by a user on a specific page in an analysis in Spotfire
Article ID: KB0071729
Updated On:
| Products | Versions |
|---|---|
| Spotfire Web Player | All |
Description
You can find more information on how to enable action logging in the TIBCO Spotfire Server Installation and Administration manual:
https://docs.tibco.com/pub/spotfire_server/12.0.2/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/enabling_action_logging_and_system_monitoring_using_the_command_line.html
This article describes a way to use the Action Logs to get the time spent on a page by a web user.
Note: Action logging can be done to either a file or a database. This article assumes that a database is used, using SQL queries to extract the desired information.
Issue/Introduction
Environment
Resolution
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 query 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
Additional Information
- Enabling action logging and system monitoring using the command line
- Action log categories
Feedback
