You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Answer Stats Table: what is it? Let's find out!

Received Response
88
Views
2
Comments
edited Jun 8, 2022 8:30AM in Agent Desktop 2 comments

Content

There have been some questions floating around recently about the Answer Stats table ('ans_stats' in the data dictionary). Perhaps a quick overview of what the data in that table means would be in order.

 

Answer Stats is a very simple table that contains the number of clicks on a given answer on a given interface during a given hour. This data is stored in the # Page Hits column ('hits' in the data dictionary).

The other columns, Rank #N, ('solved_*' in the data dictionary) are just the counts of the number of different enduser ratings for that answer/interface/time combination. This includes ratings obtained from 'Answer Feedback'. These solved_* columns are filled based on the ratings given and the maximum possible rating (at the time of rating).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!