Together-Java
Display help thread stats
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.
I have created some features for this. If we want more features, I can add those
@vishv843 Since there's no code, a bit of feedback on what i can see,
- Can we also show least used tag ?
- Total no of threads in that duration.
- Duration for which this data is displayed in days
- add units for duration(days), Average Thread Lifecycle(Hrs? Minutes?)
- It would be much better to use embed if we can instead of just text message to showcase stats
https://github.com/Together-Java/TJ-Bot/pull/1159 Check this PR out. I will add the features you have suggested
@vishv843 i believe there's been a misunderstanding with the objectives of issue #1128, we're already storing a bunch of stats in a database table named help_threads which you can use retreive possible stats for this command to showcase.
