מה שאיפות חוקר הנתונים הקרה שהמצאת?

This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a Data Explorer query, or have one to share, please start a new topic in the data & reporting category and tag it with the sql-query tag. :+1:

:information_source: For an alternative searchable list of queries that were in this topic, see @SidV’s query list on GitHub.

47 לייקים
Top user list public
Need log the who downloaded attachments
Download analytics?
How do I check a badge's status midway to it being awarded?
Tracking topic views history
Group forum members based on topics viewed?
2018: The Year in Review
Add report: Duplicate IP address
Wildcard search
What would you like to see on your Discourse 2.0 Admin Dashboard?
See who viewed topic
Is there any way to extract a URL to a post from Discourse backend DB?
2019: The Year in Review
Can all staff see all pending invites?
Automatic badge expiration
More default badges for users who flag often
Calculate total participation moments by month using Data Explorer
Data explorer queries similar to dashboard stats
Dump all conversations in a file and structured data
Retroactive topic timers
Viability of automatic index topics
2020: The Year in Review
2021: The Year in Review
Filter topics not answered by Staff
SQL query for last created users of the past 30 days
How to calculate engagement rate for Discourse?
Get topic count per month for a certain category
Useful Metric/Statics
User Messages Inbox Error 500
Maximum Number of Search Results?
User_stats with a proper time stamp
[Paid] Data explorer queries for ticketing system use case
Data explorer queries similar to dashboard stats
RGSoC 2016: Visual Forum Analytics Community Discussion
Can I find out who are 'new contributors'?
Can I access Discourse forum Database to use for PowerBI reporting?
View/read by user or of user's posts?
Is it possible to export users who were active in certain category?

Hello Super Discourse Users

I wanted to tell you that I started to “play” with the Data-Explorer plugin and I was impressed by the possibilities it offers, I’m super happy with the tool.

I am grateful to the genius who has come up with the creation of the plugin.

As I’m debugging almost every query I’ve been reading, I’ve created a repository and a list of queries.

When I can, I add improvements to the query as parameters, to make it more dynamic.

You can check the list here:

I have maintained the sources of each query in each file, so that when in doubt about the queries, they can send their doubts to the user who created it.

Thank you for any contributions you want to make, we can also use the repository as a backup of the queries you have.

Thank you in advance for making this possible.

A hug from Argentina,
SidV

22 לייקים