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?

Search for number of solved topics per user

data & reporting

osioke (Osioke Itseuwa) Split this topic April 6, 2022, 12:11pm 4

6 posts were split to a new topic: We should have a data model to make perusing the database easier

Topic		Replies	Views
How to get number of solutions per users using Data Explorer? data & reporting sql-query	10	1551	November 3, 2020
Data Explorer query for % of topics solved by specific users group data & reporting sql-query	8	668	March 4, 2021
Data Explorer query for topics N+ days old, that are unsolved data & reporting sql-query	3	418	July 19, 2023
Fetch solutions per user data & reporting solved , sql-query	1	1051	February 19, 2020
List of users by who’s solved the most topics/threads data & reporting solved , sql-query	0	83	October 8, 2018

Search for number of solved topics per user

Related Topics