Answer Stats Table: what is it? Let's find out!
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).