Display help thread stats

[ankitsmt211]

inspired from issue #660 , we started storing more data for each help_thread. The data that is stored now includes:

1. ticket_status : if the thread is active or archived
2. tags: tags used for that help_thread
3. closed_at: timestamp when the thread was last archived
4. participants: No of people that interacted with help_thread via messages (excluding OP)
5. 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,

1. Most used tag
2. Average duration of threads lifecycle(from creation to latest archival)
3. Average no of participants per thread
4. No of threads with 0 participants(no activity)
5. Total no of threads created
6. 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)
7. 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]

I have created some features for this. If we want more features, I can add those

[ankitsmt211]

@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

[vishv843]

#1159
Check this PR out. I will add the features you have suggested

[ankitsmt211]

@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.