Hey there everyone playing with Data Explorer ! (Bear with me @michebs :smiley: - I will only have two more questions, I hope other will benefit as well) Has anyone ever created a Data Explorer query for % of topics solved by specific group by month and year? So the result will be like this but th…

Ajusted. :slightly_smiling_face: -- [params] -- string :primary_group_id WITH users_groups AS ( SELECT user_id, g.id, g.name group_name FROM users u INNER JOIN user_actions ua ON ua.user_id = u.id LEFT JOIN groups g ON g.id = u.primary_group_id WHERE …

We can certainly swing something like this, all the data exists. Buy % solved … what exactly do you mean. Post is made in Jan Group awesome gets an accepted answer in Feb 73 other topics got solutions in Feb by other groups and users. So I guess “group awesome” has 1.35% solve rate for Feb?

Let’s say there is 100 solutions in a month. There are twenty people that belong to some group and people started marking their replies as solutions, overall twenty of them. I want to have a query where I will specify their primary group ID in the script and fetch the data by month to show for this …

Hi Konrad, sorry for the delay. I am still validating some queries, but I will take the opportunity to confirm, is this the result you are waiting for? year month group_name tt_groups total % 2021 1 team1 40 70 57 2021 1 team2 30 70 43

I tried to make the queries more detailed, to make it easier to understand and maintain in the future. WITH users_groups AS ( SELECT user_id, g.id, g.name group_name FROM users u INNER JOIN user_actions ua ON ua.user_id = u.id LEFT JOIN groups g ON g.id = …

No worries! You’re my saviour here! :smiley: Almost perfect! I don’t need the tt_groups and total column just the percentage number. When it comes to group_name column. It will be a query for one group so also no need to have that column. Within the query code I will just specify the primary_group_…

Perfect! That was what I’m looking for!

Consulta de Data Explorer sobre el % de temas resueltos por un grupo específico de usuarios

Comunidad Datos e informes

Konrad_Sopala (KonradSopala) 4 Marzo, 2021 11:20 15

¡Perfecto! ¡Eso es lo que estaba buscando!

Tema		Respuestas	Vistas
Search for number of solved topics per user Data & reporting sql-query	3	1033	6 Abril 2022
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	0	218	12 Febrero 2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	219	12 Febrero 2018
Topics solved by staff Data & reporting solved , sql-query	0	236	12 Febrero 2018
[PAID] Looking to get reporting queries written Marketplace	2	829	2 Junio 2020

Consulta de Data Explorer sobre el % de temas resueltos por un grupo específico de usuarios

Temas relacionados