|
Data Explorer Tutorial - Part 2 - Discourse SQL Basics
|
|
0
|
1174
|
September 5, 2023
|
|
Help modifying a query to return usernames, instead of user ID numbers
|
|
2
|
116
|
January 25, 2018
|
|
Badge ideas for Topic Voting
|
|
0
|
1809
|
June 24, 2016
|
|
Amount of time spent reading by Discourse groups
|
|
5
|
2302
|
September 11, 2020
|
|
A badge granted when someone posts a reply in a single specified topic
|
|
7
|
353
|
June 19, 2018
|
|
Weekly/Monthly/Yearly Signups
|
|
6
|
626
|
January 21, 2024
|
|
Adding a date parameter
|
|
2
|
482
|
August 22, 2023
|
|
Aggregate dashboard report data by time interval
|
|
4
|
1140
|
September 24, 2022
|
|
Recreate the Discourse user’s directory
|
|
3
|
164
|
March 13, 2020
|
|
Data Explorer query to show progress towards trust level 3 requirements
|
|
2
|
2940
|
April 29, 2023
|
|
How do I make my own badge query?
|
|
5
|
6133
|
October 10, 2016
|
|
Using STRING_AGG for Concise Query Results
|
|
0
|
2645
|
September 11, 2023
|
|
Users who like flagged posts
|
|
0
|
148
|
February 11, 2018
|
|
Handling Null Values with COALESCE
|
|
0
|
4368
|
September 13, 2023
|
|
Active users in the last 30 days
|
|
3
|
347
|
September 5, 2016
|
|
Displaying user custom fields in data explorer query results
|
|
5
|
1572
|
March 15, 2020
|
|
Lurkers who become members
|
|
0
|
121
|
September 9, 2018
|
|
The default badge queries
|
|
1
|
829
|
August 27, 2023
|
|
Add username to two queries
|
|
3
|
1657
|
January 15, 2023
|
|
How to enable Google Analytics
|
|
6
|
5663
|
September 5, 2020
|
|
Using DATE_TRUNC for Data Aggregation
|
|
0
|
2342
|
September 6, 2023
|
|
User Statistics for a particular group
|
|
0
|
107
|
April 18, 2019
|
|
Dashboard Report - Moderator Activity
|
|
6
|
592
|
February 27, 2025
|
|
Creating Network Graphs
|
|
3
|
2385
|
April 29, 2021
|
|
Categories and their Subcategories using OR
|
|
0
|
454
|
August 25, 2023
|
|
Dashboard Report - Signups
|
|
1
|
569
|
December 24, 2024
|
|
Return all non-PM topics that have not received a staff reply
|
|
0
|
214
|
August 17, 2019
|
|
Posts per category (with deleted and without deleted)
|
|
1
|
151
|
July 17, 2017
|
|
Few improvement ideas - grouping queries, duplicate queries
|
|
0
|
622
|
August 5, 2020
|
|
Create a report of users including custom fields
|
|
0
|
1048
|
November 17, 2020
|
|
Creating Custom Badges and Triggers
|
|
0
|
1617
|
August 8, 2020
|
|
Managing the performance of moderators
|
|
4
|
693
|
February 28, 2024
|
|
Time to first response for a support group
|
|
0
|
152
|
April 12, 2019
|
|
Dashboard Report - Daily Engaged Users
|
|
1
|
596
|
December 9, 2023
|
|
Replicated dashboard stats
|
|
0
|
142
|
May 11, 2020
|
|
Who has been sending the most messages in the last week?
|
|
0
|
140
|
June 5, 2017
|
|
Crawlers in a private forum?
|
|
2
|
806
|
November 16, 2019
|
|
Is there any way of telling how popular a Theme is?
|
|
5
|
936
|
September 1, 2018
|
|
Tips for Exporting User Data
|
|
0
|
217
|
June 26, 2024
|
|
'Emeritus' Badge for higher Trust Levels
|
|
0
|
121
|
February 27, 2015
|
|
Number of topics per tag
|
|
2
|
1214
|
January 29, 2020
|
|
Get list of topics pinned globally
|
|
7
|
2341
|
January 20, 2022
|
|
Users In Specific Group(s) BUT NOT In Other Group(s)
|
|
0
|
117
|
May 14, 2019
|
|
How to calculate engagement rate for Discourse?
|
|
7
|
1300
|
December 21, 2022
|
|
Data Explorer averages by year?
|
|
6
|
1342
|
May 17, 2020
|
|
User Notes History
|
|
0
|
351
|
September 13, 2023
|
|
Is it possible to see the topics a user has viewed?
|
|
3
|
1722
|
June 21, 2020
|
|
Is there a way to Search by Posts with No Staff replies on it
|
|
4
|
1534
|
August 17, 2019
|
|
Data explorer query to return certain post notices?
|
|
5
|
404
|
November 19, 2020
|
|
How does Meta handle the bug reporter badge?
|
|
3
|
445
|
August 2, 2023
|