Where can I see the code for Dashboard Reports?

[JammyDodger]

@Nesha

But we wander is it possible to see the SQL behind standard reports available on Discourse Dashboard?

I think those ones are found in https://github.com/discourse/discourse/tree/main/app/models/concerns/reports, though may not be as easy to decipher as some of the ones shared in data-explorer topics.

There are some good tricks in this topic too for some of the Data-Explorer automagic you can leverage to make the results more interactive:

IDs in Data Explorer

There are actually quite a few other little tricks to beautifying your results in the Discourse UI. [Screen Shot 2022-04-19 at 7.45.42 PM] This old file shows some examples: I’ll integrate this into the main Data Explorer topic at some point when I have a spare moment.

If there are any queries in particular you’re trying to create feel free to spin up a topic and ‘think out loud’, as we’re always looking for more examples we can add to our community pool.