Is there a way to see hourly post data?

[Tang]

Hi Discourse!

I’d like to see which hours are most popular for people posting to our community, is there something in Admin to see this? I can see total posts per day in the current dashboard.

Thanks

[pfaffman (Jay Pfaffman)]

I’m also interested in being able to add custom date ranges to the user stats page. For example, I’d like to be able to get stats for a particular week rather than have them be based on today. I’ve poked around as described here How to reverse engineer the Discourse API, but I didn’t see a way to change the date range.

[zogstrip (Régis Hanol)]

That’s something for the Data Explorer plugin. Maybe there’s already an example in

What cool data explorer queries have you come up with?

Continuing the discussion from Data Explorer Plugin: For a searchable list of queries in this topic, see @SidV’s query list on GitHub. This topic has become too long to be easily searched. If you have questions about how to write a Data Explorer query, start a new topic in the #support category and tag it with data-explorer. Here’s a couple I’m starting with: Users Last Seen Since (Since N Weeks Ago) with intervals as ( select n as start_time, CURRENT_TIMEST…