Knowledge BaseMetrics & Reports Statistical queries (SQL statements)Why is there an anomalous number of element views being logged in the dashboard database?

Why is there an anomalous number of element views being logged in the dashboard database?

ISSUE

There's an unusually high number of view times being logged in an engagement report that queries the dashboard_element_view_log_detail table. Why is this happening? Nobody is viewing the element that many times!

RESOLUTION

The issue is that the system generates a "view" each time an image is generated from a report dataset. These "views" are currently being logged to the dashboard_element_view_log_detail table. All of these "fake views" are assigned to an administrator user with the lowest user_id. Please use following sql statement to find this Administrator user:
select user_id, username, first_name, last_name from user where is_administrator_ind = "Y" order by user_id asc limit 1;

Please exclude view logs for this user from your engagement report (in the SQL statement) to avoid displaying unusually high number of element views that are not really "views."

0 Comments

Add your comment

E-Mail me when someone replies to this comment