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 для % тем, решённых конкретной группой пользователей

Создание сообщества Данные и отчетность

Konrad_Sopala (KonradSopala) 04.Март.2021 11:20:24 15

Отлично! Это именно то, что я искал!

Тема		Ответов	Просм.
Search for number of solved topics per user Data & reporting sql-query	3	1032	06.04.2022
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	0	217	12.02.2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	219	12.02.2018
Topics solved by staff Data & reporting solved , sql-query	0	236	12.02.2018
[PAID] Looking to get reporting queries written Marketplace	2	829	02.06.2020

Запрос Data Explorer для % тем, решённых конкретной группой пользователей

Связанные темы