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