When looking at my forum, I generally see that there are more posts in specific hours than others. Is there a way that we can get a statistic that shows specifically; in hours how many posts how many page views etc. like there is day by day, instead; hour by hour.

I wish, the thing is is that I use Communiteq (formerly DiscourseHosting), so I’m not able to install plugins.

Then there’s not much you can do, unfortunately!

The query below will show posts created per hour of the day. -- [params] -- int :months_ago = 1 WITH query_period AS (SELECT date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' AS period_start, date_trunc('month', CURRENT_DATE) - IN…

What do I do with that code in order to install it?

I was able to activate it, I just don’t know how to use that code to make it actually work

For date explorer press run [image]

Go to Admin - Plugins - Data Explorer . Press the + button on the top right. Enter “post per hour” in the input box left to the “Create New” button and press the button. Copy/paste the code so it replaces the SELECT 1 text. Click ‘Save changes and run’ If you need more guidance, please contact supp…

Hour By Hour Statistics

Community Building Data & reporting

codinghorror (Jeff Atwood) November 16, 2020, 1:34am 5

You should email them for support.

Topic		Replies	Views
Tracking discourse usage by hour? Data & reporting	2	881	September 2, 2020
Daily graph of user time online Feature	2	2299	October 1, 2015
Is there a plugin for detecting forum access data? Data & reporting	3	613	November 21, 2023
Discourse forum traffic query data Product Support	2	837	May 28, 2021
Report for top page hit counter and page generation time per IP address or user Data & reporting	2	715	December 6, 2022

Hour By Hour Statistics

Related topics