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 查询：特定用户组解决主题的百分比

社区数据与报告

michebs (Michelle) 2021 年3 月 4 日 10:30 11

你好，Konrad，抱歉迟复。
我仍在验证一些查询，但借此机会确认一下：这是您期待的结果吗？

year	month	group_name	tt_groups	total	%
2021	1	team1	40	70	57
2021	1	team2	30	70	43

话题		回复	浏览量
Search for number of solved topics per user Data & reporting sql-query	3	1033	2022 年4 月 6 日
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	0	218	2018 年2 月 12 日
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	219	2018 年2 月 12 日
Topics solved by staff Data & reporting solved , sql-query	0	236	2018 年2 月 12 日
[PAID] Looking to get reporting queries written Marketplace	2	829	2020 年6 月 2 日

Data Explorer 查询：特定用户组解决主题的百分比

相关话题