Crazy idea

How easy would it be to get a spreadsheet of the number of Discourse posts for each one hour slot over the last month?

I have a silly idea I’d like to try and this would be step one.

An SQL query for this should be possible. Let me have a look into it…

Yes I can do this.

Do you want an aggregate for the whole month? Or each hour of each day in that month?

Each hour of reach day in the month please.

Thank you for indulging me!

posts-per-hour@discourse-southlondonmakerspace-org-2016-04-14.dcqresult.xls (247.5 KB)

Have all the months :slight_smile:

1 Like

Thank you. That’s exactly what I was looking for!

1 Like