Hi All, I am looking to build a query in the data explorer - and being completely new to it, am not sure where to start! I would like to run the following query: Return the number of topics with a post marked as a solution by folk not in a given group, for a start and end date. I couldn’t see an…

Hello and welcome @lju :slight_smile: This topic has a couple of examples in to get you started - How to get number of solutions per users using Data Explorer?

Hi @JammyDodger Thanks for that - it was helpful, and I think I got my head around the various fields :slight_smile: As a former data architect, I dream of having some sort of a data model to refer to, hint, hint… Cheers, Lju

[изображение] A data model to make perusing the database easier I need the users table, the user_actions table, and the groups table. I think you should be able to do it with two if you use group_users. Maybe something like: -- [params] -- string :group_name = staff -- date :date_from = 01/04…

Поиск количества решённых тем по пользователю

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

JammyDodger 05.Апрель.2022 16:46:59 2

Привет и добро пожаловать @lju

В этой теме есть несколько примеров, которые помогут вам начать работу — How to get number of solutions per users using Data Explorer?

Тема		Ответов	Просм.
Fetch solutions per user Data & reporting sql-query , solved	1	1118	19.02.2020
How to get number of solutions per users using Data Explorer? Data & reporting sql-query	10	1705	03.11.2020
Data Explorer query for % of topics solved by specific users group Data & reporting sql-query	8	781	04.03.2021
How do I see who is marking solved and on what? Data & reporting solved , sql-query	11	2435	08.06.2024
Questions Solved and Currently Assigned Topics by User per Month Data & reporting solved , sql-query	1	234	06.04.2024

Поиск количества решённых тем по пользователю

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