Analyze number of posts made daily since the board started

Looking for an Extension? Have an Extension request? Post your request here for help. (Note: This forum is community supported; while there is an Extensions Development Team, said team does not dedicate itself to handling requests in this forum)
Get Involved
Post Reply
User avatar
lurttinen
Translator
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka
Contact:

Analyze number of posts made daily since the board started

Post by lurttinen » Tue Mar 28, 2017 7:08 pm

Jup,

Need an extension that would show how many posts/topics were made day by day since the board started.
preferably with some nice graphs. Or export the data to excel?

The average posts per day in ACP is not enough. I want every day, all day. ;) ;)
Signature is here

User avatar
Neculai Anisor
Registered User
Posts: 172
Joined: Tue Jan 08, 2013 9:36 pm
Location: Renfrew, Renfrewshire, Scotland
Name: Neculai Anișor
Contact:

Re: Analyze number of posts made daily since the board started

Post by Neculai Anisor » Tue Mar 28, 2017 7:21 pm

Maybe the extension 24 Hour Activity Stats will give you the result you need?
Image | Romanian Support Team | Animo @ phpBB.ro - Administrator

User avatar
lurttinen
Translator
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka
Contact:

Re: Analyze number of posts made daily since the board started

Post by lurttinen » Tue Mar 28, 2017 7:32 pm

Neculai Anisor wrote:
Tue Mar 28, 2017 7:21 pm
Maybe the extension 24 Hour Activity Stats will give you the result you need?
No,
My board started January 2002, and i need post counts from every day since then.
That's about 5000 days and number of posts and topics made each day. :)

I don't need the average values ACP gives. Or 24 hour stats.. I need it since the beginning. :lol:
I'm looking to see how the popularity has changed over the years and if there is any difference, say in the summer or in the winter.
Signature is here

User avatar
Neculai Anisor
Registered User
Posts: 172
Joined: Tue Jan 08, 2013 9:36 pm
Location: Renfrew, Renfrewshire, Scotland
Name: Neculai Anișor
Contact:

Re: Analyze number of posts made daily since the board started

Post by Neculai Anisor » Tue Mar 28, 2017 7:34 pm

So you want to show the acp statistics of the topics made daily in the index page?
Image | Romanian Support Team | Animo @ phpBB.ro - Administrator

User avatar
lurttinen
Translator
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka
Contact:

Re: Analyze number of posts made daily since the board started

Post by lurttinen » Tue Mar 28, 2017 7:38 pm

No, I don't need them to be visible anywhere else than the ACP. Maybe not even in the ACP, but to download a file and import into excel.

It is just for me to do statistics.

EDIT:

I want to pick a date, say 2.8.2005 and it would spit out the number of topics and posts made in that day.
And export the whole history in excel.
Signature is here

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69426
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Analyze number of posts made daily since the board started

Post by KevC » Tue Mar 28, 2017 7:42 pm

You could extract the post date time stamp column from the posts table in the database. Convert it from unix time to normal dates. That would give you a data point for every post. That should be enough to produce a graph of posting trends.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Post Reply

Return to “Extension Requests”