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!

Data Explorer Abfrage für % der von einer bestimmten Benutzergruppe gelösten Themen

Gemeinschaft Daten & Berichterstattung

Konrad_Sopala (KonradSopala) 4. März 2021 um 11:20 15

Perfekt! Das ist genau das, was ich gesucht habe!

Thema		Antworten	Aufrufe
Search for number of solved topics per user Data & reporting sql-query	3	1033	6. April 2022
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	0	218	12. Februar 2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	219	12. Februar 2018
Topics solved by staff Data & reporting solved , sql-query	0	236	12. Februar 2018
[PAID] Looking to get reporting queries written Marketplace	2	829	2. Juni 2020

Data Explorer Abfrage für % der von einer bestimmten Benutzergruppe gelösten Themen

Verwandte Themen