Display help thread stats
ankitsmt211 opened this issue · 4 comments
ankitsmt211 commented
inspired from issue #660 , we started storing more data for each help_thread. The data that is stored now includes:
- ticket_status : if the thread is active or archived
- tags: tags used for that help_thread
- closed_at: timestamp when the thread was last archived
- participants: No of people that interacted with help_thread via messages (excluding OP)
- message_count: No of messages that were sent in the thread till it's archived
Our goal is somehow showcase stats related to help_thread, which can now be done using slash commands.
help-thread-stats
-> command to show case stats, it should take option such as duration
as a choice.
Duration choices will be 1 day, 7 days, 30 days, 90 days and 180 days(default can be 1 day if not provided)
Possible data to showcase,
- Most used tag
- Average duration of threads lifecycle(from creation to latest archival)
- Average no of participants per thread
- No of threads with 0 participants(no activity)
- Total no of threads created
- Average no of messages per thread(this data could be off at times, since message count is updated on archival of thread instead on every message sent)
- Most active duration throughout a day(when most of threads are created)
This is top of my mind, ofc we can showcase more cool stuff if possible. This is open for discussion.
vishv843 commented