| Author |
 Topic  |
|
|
CHEETAH
New Member
Sweden
60 Posts |
 Posted - 11 May 2001 : 09:07:50
|
Hi!
Can anyone do a statistics page based on the forums database?
I'd like it to have the folowing statistics:
all the different days in a graphical view, so that you can see the posts/day rising.
number of posts a week in the same sort of graphical view
number of posts a month in the same sort of graphical view
Number of registered members/day in the same sort of graphical view
number of topics a day in the same sort of graphical view
number of topics a week in the same sort of graphical view
number of topics a month in the same sort of graphical view
cheers
/CHEETAH - [former "Stockholmstudent]- www.diskuterapolitik.com |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 13:22:14
|
interesting...
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
 |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 11 May 2001 : 14:42:18
|
You could use this as a starting point.....
http://forum.snitz.com/forum/link.asp?TOPIC_ID=5264
<edit>Helps if I put the link </edit>
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Edited by - davemaxwell on 11 May 2001 14:43:46 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 15:27:00
|
what kind of graphical view are you thinking of? a bar graph probably huh?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
CHEETAH
New Member
Sweden
60 Posts |
Posted - 11 May 2001 : 16:24:51
|
yeah with bars .Lines between them would be great, but probably too difficult. Can you manage to develope this? I know nothing about ASP myself! 
the link http://forum.snitz.com/forum/link.asp?TOPIC_ID=5264 refers to a statistic mod that is based on IP-numbers and such! Not on the forum's database! It's two very different things! :)
cheers
/CHEETAH - [former "Stockholmstudent]- www.diskuterapolitik.com
Edited by - CHEETAH on 11 May 2001 16:26:28 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 16:54:46
|
yeah i agree it's way too different things.
however my statistics mod is very similiar, I've spent last hour and a half on coming up with something and progress looks good  . Just Straight numbers and no graphs yet though.
http://www.iamviet.com/forum/statistics2.asp
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
CHEETAH
New Member
Sweden
60 Posts |
Posted - 14 May 2001 : 10:47:51
|
yeah!
Great! One thing to say only: could you make it not to show the dates that havn't been yet!? like December and so? It takes up soo much space! And maybe the graphs too?
I also wonder what mod you use on your site to send those messages that pops up to the members?
cheers
/CHEETAH |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 14 May 2001 : 13:18:27
|
when i was creating this, originally i had it only display from the current day and current month down to january. But I gave it some thought and there would probably no info for 1st of the months and for january. You would only see 1 month or just a few days if it's the start of the month. These numbers are not useful by themselves. Only useful when viewed with other numbers. Might was well show all the months and days.
Another reason for displaying all the months and days was, i wanted to display the current month/day stats and maybe after it display the historic average. It would be useful as a comparison tool. However, couldn't think of a way to take average on a count function in sql. it was complaining about "cannot perform aggregate function on another aggregate function." oh wells.
About the graph, I tried it a bit and it can show up as a bar graph. However the scale of it is tricky. For my iamviet site, the numbers of posts per month was in thousands and for my dev site it's in the 10-100's. If i scale it for one, it shows up differently for the other. Also to actually scale it right I would probably need to take the max value of the counts but the way it's programmed right now, i can't really do that. It's calling a select statement and does a loop to display it, so the current one does not know the value of the next one. I would need to store the values in an array or something and then display it. Since this is just to make it look better, I'm not going to put much time into it right now. I'm working on a MOD Download thingy and if I find some spare time, then i might do the graph for this. Maybe someone else can try it too  .
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
CHEETAH
New Member
Sweden
60 Posts |
Posted - 14 May 2001 : 16:41:45
|
quote:
when i was creating this, originally i had it only display from the current day and current month down to january. But I gave it some thought and there would probably no info for 1st of the months and for january. You would only see 1 month or just a few days if it's the start of the month. These numbers are not useful by themselves. Only useful when viewed with other numbers. Might was well show all the months and days.
But I mean the ones that shows months and days etc. that hasn't been yet! Like December 2001 and so on! Offcourse months like January 2001 is fun to show, so you can compare how the site developes in visitors etc. But there is absolutely no need to see the months that hasn't yet existed! It just takes up room! Don't you think? Hope I didn't missunderstand you!
quote:
Another reason for displaying all the months and days was, i wanted to display the current month/day stats and maybe after it display the historic average. It would be useful as a comparison tool. However, couldn't think of a way to take average on a count function in sql. it was complaining about "cannot perform aggregate function on another aggregate function." oh wells.
About the graph, I tried it a bit and it can show up as a bar graph. However the scale of it is tricky. For my iamviet site, the numbers of posts per month was in thousands and for my dev site it's in the 10-100's. If i scale it for one, it shows up differently for the other. Also to actually scale it right I would probably need to take the max value of the counts but the way it's programmed right now, i can't really do that.
yeah.. that was the way I thought would maybe work. Just like on http://www.thecounter.com. That's how I'd like it to look.
quote:
It's calling a select statement and does a loop to display it, so the current one does not know the value of the next one. I would need to store the values in an array or something and then display it. Since this is just to make it look better, I'm not going to put much time into it right now. I'm working on a MOD Download thingy and if I find some spare time, then i might do the graph for this. Maybe someone else can try it too .
A dl-mod would be nice. Very much nicer with graphs! Unfortunately I know nothing about ASP and I really must study for an Italian-test right now, so I can't help much either. Hope someone else helps! I really thank you for making something out of this idea of mine. Thanks alot buddy!
cheers
/CHEETAH - Stockholm Sweden - 18 - cheetah@plus.idg.se - http://www.diskuterapolitik.com
|
|
|
| |
Topic |
|
Topic Locked
