Time to first group response for topics created within a given time period Returns the time to first response by a member of a given group to “regular” (not Personal Message) topics created by a user who is not a member of the given group. The query’s :group_name parameter is set to “staff” by defau…

[image] Irene Tolentino: Is this code still viable or is there an updated version? It’s not. Honestly, I’m not sure how it ever worked. I’ll post an updated version soon and ping you to let you know it’s ready. Edit: @IreneT Here’s a fixed version of the original query. I’d ignore that quer…

@simon Looking forward to it. Much appreciated. Thanks

[image] simon: I’m finding that I have to refresh the page after saving a Data Explorer query in order for the parameter input fields to show up below the query. (That may just be a quirk on my local development site.) No, unfortunately this is a known thing. A quick refresh does the trick th…

This is perfect @simon . Super appreciate your help on this. Just a little tweak from our end to have the data we need, but I think we’re good. Thanks so much :heart:

Hi @simon We have installed Data Explorer and used the codes you shared. What we specifically want is to have the Time to first response by name of each group member. However, the query is sending response times grouped by the category ID and not the user ID. [image (1)] Would appreciate your he…

[image] Irene Tolentino: What we specifically want is to have the Time to first response by name of each group member. Thanks for bringing this up, because there’s an error in the queries that I posted: EXTRACT(MINUTE FROM (p.created_at - t.created_at)) AS response_time_minutes That line is…

[image] Irene Tolentino: What we specifically want is to have the Time to first response by name of each group member. I’m assuming you want the average time to first response per group member, if you just want the time it took group members to respond to individual topics, use the fixed vers…

Thanks @simon - very helpful and fast response as always. Really appreciate it! Actually, our objective is for our coaches (added in one of the groups) to measure their average response time. This way we have a reference on how well we’re doing when it comes to providing community support in discou…

[image] Irene Tolentino: our objective is for our coaches (added in one of the groups) to measure their average response time. This way we have a reference on how well we’re doing when it comes to providing community support in discourse and ensuring satisfied members in the long run. That ma…

Time to first response by group members

Community Building Data & reporting

IreneT (Irene Tolentino) September 27, 2023, 6:13pm 2

Hi @simon

Thanks for sharing a potential solution to generate reports for time to respond by staff monthly. Is this code still viable or is there an updated version? Also, is there a way to make this report on a weekly basis vs monthly? Thanks so much

Topic		Replies	Views
Dashboard Report - Time to First Response Data & reporting sql-query , dashboard-reports , dashboard-sql	0	485	December 14, 2023
Time to first response for a support group Data & reporting sql-query	0	197	April 12, 2019
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	210	July 23, 2026
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	20	5777	December 20, 2018
Average Staff Response Times to Topics Data & reporting sql-query	3	303	May 3, 2024

Time to first response by group members

Related topics