|
Data Explorer Tutorial - Part 2 - Discourse SQL Basics
|
|
0
|
1272
|
September 5, 2023
|
|
Help modifying a query to return usernames, instead of user ID numbers
|
|
2
|
121
|
January 25, 2018
|
|
A badge granted when someone posts a reply in a single specified topic
|
|
7
|
371
|
June 19, 2018
|
|
Amount of time spent reading by Discourse groups
|
|
5
|
2367
|
September 11, 2020
|
|
Weekly/Monthly/Yearly Signups
|
|
6
|
643
|
January 21, 2024
|
|
Adding a date parameter
|
|
2
|
496
|
August 22, 2023
|
|
Aggregate dashboard report data by time interval
|
|
4
|
1153
|
September 24, 2022
|
|
The default badge queries
|
|
1
|
890
|
August 27, 2023
|
|
Recreate the Discourse user’s directory
|
|
3
|
180
|
March 13, 2020
|
|
Data Explorer query to show progress towards trust level 3 requirements
|
|
2
|
2954
|
April 29, 2023
|
|
Users who like flagged posts
|
|
0
|
154
|
February 11, 2018
|
|
Using STRING_AGG for Concise Query Results
|
|
0
|
2687
|
September 11, 2023
|
|
How do I make my own badge query?
|
|
5
|
6155
|
October 10, 2016
|
|
Handling Null Values with COALESCE
|
|
0
|
4451
|
September 13, 2023
|
|
Active users in the last 30 days
|
|
3
|
373
|
September 5, 2016
|
|
Lurkers who become members
|
|
0
|
127
|
September 9, 2018
|
|
Displaying user custom fields in data explorer query results
|
|
5
|
1596
|
March 15, 2020
|
|
Add username to two queries
|
|
3
|
1661
|
January 15, 2023
|
|
How to enable Google Analytics
|
|
6
|
5767
|
September 5, 2020
|
|
Using DATE_TRUNC for Data Aggregation
|
|
0
|
2389
|
September 6, 2023
|
|
User Statistics for a particular group
|
|
0
|
111
|
April 18, 2019
|
|
Dashboard Report - Moderator Activity
|
|
6
|
653
|
February 27, 2025
|
|
Creating Network Graphs
|
|
3
|
2405
|
April 29, 2021
|
|
Categories and their Subcategories using OR
|
|
0
|
469
|
August 25, 2023
|
|
Dashboard Report - Signups
|
|
1
|
586
|
December 24, 2024
|
|
Posts per category (with deleted and without deleted)
|
|
1
|
163
|
July 17, 2017
|
|
Return all non-PM topics that have not received a staff reply
|
|
0
|
226
|
August 17, 2019
|
|
User Notes History
|
|
0
|
360
|
September 13, 2023
|
|
Few improvement ideas - grouping queries, duplicate queries
|
|
0
|
623
|
August 5, 2020
|
|
Create a report of users including custom fields
|
|
0
|
1052
|
November 17, 2020
|
|
Creating Custom Badges and Triggers
|
|
0
|
1658
|
August 8, 2020
|
|
Managing the performance of moderators
|
|
4
|
709
|
February 28, 2024
|
|
Time to first response for a support group
|
|
0
|
158
|
April 12, 2019
|
|
Dashboard Report - Daily Engaged Users
|
|
1
|
625
|
December 9, 2023
|
|
Tips for Exporting User Data
|
|
0
|
263
|
June 26, 2024
|
|
Who has been sending the most messages in the last week?
|
|
0
|
147
|
June 5, 2017
|
|
Replicated dashboard stats
|
|
0
|
145
|
May 11, 2020
|
|
Crawlers in a private forum?
|
|
2
|
813
|
November 16, 2019
|
|
Is there any way of telling how popular a Theme is?
|
|
5
|
956
|
September 1, 2018
|
|
'Emeritus' Badge for higher Trust Levels
|
|
0
|
124
|
February 27, 2015
|
|
Number of topics per tag
|
|
2
|
1233
|
January 29, 2020
|
|
How to calculate engagement rate for Discourse?
|
|
7
|
1337
|
December 21, 2022
|
|
Users In Specific Group(s) BUT NOT In Other Group(s)
|
|
0
|
119
|
May 14, 2019
|
|
Get list of topics pinned globally
|
|
7
|
2358
|
January 20, 2022
|
|
Data Explorer averages by year?
|
|
6
|
1351
|
May 17, 2020
|
|
Dashboard Report - Trending Search Terms
|
|
0
|
351
|
December 13, 2023
|
|
Is it possible to see the topics a user has viewed?
|
|
3
|
1752
|
June 21, 2020
|
|
Is there a way to Search by Posts with No Staff replies on it
|
|
4
|
1545
|
August 17, 2019
|
|
Data explorer query to return certain post notices?
|
|
5
|
416
|
November 19, 2020
|
|
Cohort Analysis Report - Monthly User Activity by Posts and Solutions
|
|
0
|
301
|
March 28, 2024
|