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) 3월 4, 2021, 11:20오전 15

완벽해요! 바로 제가 찾던 거였어요!

글		댓글	조회수
Search for number of solved topics per user Data & reporting sql-query	3	1033	4월 6, 2022
Topics solved by regular users (lists topics) Data & reporting solved , sql-query	0	217	2월 12, 2018
Topics solved by staff (lists topics) Data & reporting solved , sql-query	0	219	2월 12, 2018
Topics solved by staff Data & reporting solved , sql-query	0	236	2월 12, 2018
[PAID] Looking to get reporting queries written Marketplace	2	829	6월 2, 2020

특정 사용자 그룹의 토픽 해결률 %를 조회하는 Data Explorer 쿼리

Related topics