Chat Time Taken Measure

[AndyGilly]

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

thanks

Andy

[Steven Boardman]

@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

 

 

 

 

 

 

[AndyGilly]

thanks @Steven Boardman, really appreciated