Forum Discussion
Chat statistics
Hi community, I have export from chat. It includes some information like ID's of chat, users, support or text of message etc. Below is simplified example. The column "# of message from „who“" is ...
Hi Divous ，
Not quite sure what you need. Do you want to get the number of communications between the support and the user when solving a problem? Like the value given in the field [# of message from "who"] in the example table you gave? Also, you want to get the average time per communication and create a graphical chart that is easy to understand, right? Could you please provide more example data in Text format and share the logic of the calculation based on the example data given (e.g. chat_id 006jIhMDiPOZ in the table below, why the final value of field [# of message from "who"] are ,1, 1, 2, 2, 3,3,3,4? How to get the average time?) and the final result you want. Thank you.
Best Regards