Don't have an account? Register now to chat, post, use our tools, and much more.
Latest Headlines
Online Users
There are 122 users online: 11 members, 87 guests and 24 bots.
Members: cvsoft, leafiness0, Link, Tari, tr1p1ea.
Bots: Magpie Crawler (3), Googlebot (20), MSN/Bing (1).
RSS & Social Media
SAX
You must log in to view the SAX chat widget
|
| Author |
Message |
|
KermMartian
Site Admin
Joined: 14 Mar 2005
Posts: 55882
Location: Earth, Sol, Milky Way
|
 Posted: 31 Aug 2010 01:40:13 am Post subject: Daily Stats Graph |
 |
|
For quite a while, I've been occasionally generating post activity graphs in Excel, using a CSV day,post values dumped from a custom script on Cemetech. For a few days I have been wanting to make a PHP script that would automatically generate such graphs for me, and after an evening of stealing code from my wonderful and sadly no-longer-active WorldTrends project, discontinued because it was sucking down massive amounts of Jatol's CPU time and memory space, I have a nice automatically-generated graph up and running. At 4am every morning, the cron job that performs backend Cemetech maintenance like archives statistics updates, SAX log cleanup and archiving, SourceCoder cache cleanup, and front-page stats updating will regenerate the following graph. Notice that it shows a graph of daily posts, including data points at the actual postcount for each day, plus a 30-day moving average (black thick line).
As you can see, within August 2010 we had our first two 300+ post days since early 2005, and the 30-day moving average is surging towards 150 posts per day. Please feel free to comment onand suggest improvements to this graph, I'd be happy to generate additional graphs like member growth over time, topic creation over time, and other similar data, and here's to a fall of heavy posting!
_________________
 
 
 |
|
| Back to top |
|
|
comicIDIOT
Guru
Joined: 01 May 2006
Posts: 5140
Location: SFBA, California
|
| Posted: 31 Aug 2010 02:17:06 am Post subject: |
|
|
It's coming! Our Calculator wall at work is cleaned out! We do have some scientific calculators left, however!
Wow, there's a long period of inactivity around April 2007 it seems. I was here during that time but can't recall anything being _that_ slow.
Now, you just need to AJAX-ifiy it and add comments on some parts so we can see the data over a week, month, year or since the data is available and read certain points. Kinda of like the Stock charts on Google 
_________________
-Alex |
|
| Back to top |
|
|
KermMartian
Site Admin
Joined: 14 Mar 2005
Posts: 55882
Location: Earth, Sol, Milky Way
|
| Posted: 31 Aug 2010 09:30:07 am Post subject: |
|
|
| comicIDIOT wrote: | | It's coming! Our Calculator wall at work is cleaned out! We do have some scientific calculators left, however! |
Woohoo! I hope you told all the purchasers about Cemetech.
| comicIDIOT wrote: | | Wow, there's a long period of inactivity around April 2007 it seems. I was here during that time but can't recall anything being _that_ slow. |
If you're talking about the Jatol incident, that's just two or three months of lost posts, not an actual lack of activity.
| comicIDIOT wrote: | | Now, you just need to AJAX-ifiy it and add comments on some parts so we can see the data over a week, month, year or since the data is available and read certain points. Kinda of like the Stock charts on Google |
That's what WorldTrends was like, and the load from its calculations brought my server to its knees. I'd rather not jeopardize my hosting again. 
_________________
|
|
| Back to top |
|
|
KermMartian
Site Admin
Joined: 14 Mar 2005
Posts: 55882
Location: Earth, Sol, Milky Way
|
| Posted: 31 Aug 2010 10:43:56 am Post subject: |
|
|
*premature bump*
I added a new About | Site Statistics page that shows the statistics numbers on the front page as well as the daily posts graph. It's pretty rudimentary at the moment, and I definitely intend to expand it.
http://www.cemetech.net/about/stats.php
_________________
|
|
| Back to top |
|
|
comicIDIOT
Guru
Joined: 01 May 2006
Posts: 5140
Location: SFBA, California
|
| Posted: 31 Aug 2010 05:22:08 pm Post subject: |
|
|
The lack of attention in this thread is dissapointing :'( Haha
It's looking pretty good. Add some padding to that image and you're set! Maybe some more words and explanations for the lower & higher parts of the graph.
| KermMartian wrote: | | comicIDIOT wrote: | | It's coming! Our Calculator wall at work is cleaned out! We do have some scientific calculators left, however! |
Woohoo! I hope you told all the purchasers about Cemetech. |
No  I don't work in that section of the store all that often. And, when I do I haven't told anyone yet because they've all be with parents. Not that we're a bad influence (or programming) but parents don't like hearing about possible distractions. 
| Quote: | | comicIDIOT wrote: | | Wow, there's a long period of inactivity around April 2007 it seems. I was here during that time but can't recall anything being _that_ slow. |
If you're talking about the Jatol incident, that's just two or three months of lost posts, not an actual lack of activity. |
Whenever I hear Jatol I think of the Jato Rockets
| Quote: | | comicIDIOT wrote: | | Now, you just need to AJAX-ifiy it and add comments on some parts so we can see the data over a week, month, year or since the data is available and read certain points. Kinda of like the Stock charts on Google |
That's what WorldTrends was like, and the load from its calculations brought my server to its knees. I'd rather not jeopardize my hosting again. |
Oh I see!
_________________
-Alex |
|
| Back to top |
|
|
KermMartian
Site Admin
Joined: 14 Mar 2005
Posts: 55882
Location: Earth, Sol, Milky Way
|
| Posted: 31 Aug 2010 05:31:14 pm Post subject: |
|
|
| comicIDIOT wrote: | | The lack of attention in this thread is dissapointing :'( Haha |
Tell me about it. It's a pretty nifty script in my opinion.
| comicIDIOT wrote: | | It's looking pretty good. Add some padding to that image and you're set! Maybe some more words and explanations for the lower & higher parts of the graph. |
Yeah, that's a good idea, I'll probably put those on the new Cemetech | About | site Statistics page that I started today. I added some padding to the right side of the graph; you think it needs more?
_________________
|
|
| Back to top |
|
|
|
Register to Join the Conversation
Have your own thoughts to add to this or any other topic? Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget? Registration for a free Cemetech account only takes a minute.
» Go to Registration page
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
© Copyright 2000-2013 Cemetech & Kerm Martian :: Page Execution Time: 0.032817 seconds.
|
![[t]](/forum/templates/Cemetech6/images/twitter.png)
![[t]](/forum/templates/Cemetech6/images/fb.png)
![[RSS]](/forum/templates/Cemetech6/images/rss.png)
