Jump to content

Chat Time Taken Measure


Recommended Posts

I am wondering if anyone can help??

I would like to look create a measure to look at the average time taken to resolve a chat enquiry during our trial

I have tried a date diff sql statement using the created and closed variables without success



Link to comment
Share on other sites

@AndyGilly the h_close_time value (in secs) in the h_lc_sessions table, is the duration of each chat session so if you are looking for an average, i would suggest using this value 

h_close_time (Close Time) Time Chat Was Active For INTEGER

Something like this for the average over a defined period. 




Hope that helps








  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...