Forum | EnterTheSoulAsylum.com
http://enterthesoulasylum.com/forum/

Show statistics now available
http://enterthesoulasylum.com/forum/viewtopic.php?f=4&t=1116
Page 1 of 1

Author:  Homesick [ Mon Mar 07, 2011 7:01 pm ]
Post subject:  Show statistics now available

I just compiled a bunch of statistics pulled straight from our archive of shows, such as the total number of shows, most popular venue, number of countries played and so forth. Since I figured lots of other fans would be interested, I also put them all up in a brand-new statistics section.

There's lots of other stuff to measure, of course. If there's anything in particular that you would like to see, share your ideas in this thread!

Note: All of the statistics are loaded dynamically from our database, so they will update automatically as new shows are added.

Author:  dells [ Mon Mar 07, 2011 8:00 pm ]
Post subject:  Re: Show statistics now available

This is an awesome and interesting addition to the site, Thanks!

On the default overall results page, is it possible to provide links to be able to request results based just on the data from the last 10 yrs and last 5 yrs?

Author:  Homesick [ Mon Mar 07, 2011 8:03 pm ]
Post subject:  Re: Show statistics now available

dells wrote:
This is an awesome and interesting addition to the site, Thanks!

On the default overall results page, is it possible to provide links to be able to request results based just on the data from the last 10 yrs and last 5 yrs?


It would be possible with some extra work. If there's considerable interest in such a feature, I might take the time to add it.

Author:  AlyssaJones [ Mon Mar 07, 2011 9:10 pm ]
Post subject:  Re: Show statistics now available

Homesick wrote:
I just compiled a bunch...


I? Don't be taking all the credit there Jakob, Jim tells me he helped with this too ;)

Nice work though guys. I find the stats pretty interesting. :)

I think if you felt like it and had the time to do it, it would be interesting to see the stats broken down by time period like Dells suggested. They don't get out to California much anymore... and Pennsylvania? Sometimes I think there's some sort of anti-Soul Asylum force field at work nowadays keeping them from this entire region :P

Author:  Monolith Maniac [ Tue Mar 08, 2011 12:55 am ]
Post subject:  Re: Show statistics now available

AlyssaJones wrote:
Homesick wrote:
I just compiled a bunch...


I? Don't be taking all the credit there Jakob, Jim tells me he helped with this too ;)


No, he deserves the credit for the compiling of the statistics page. The only contributing I really have doing towards the stats section is having to manually enter the records for the shows (which may/will change the outcome of some of those results). ;)

The page is automatically updated so nothing needs to be typed in (i.e. when another show is entered in the archive for them playing at First Avenue, the show count for the venue will go up one more on the stats page)... pretty sophisticated. :)

Author:  AlyssaJones [ Tue Mar 08, 2011 1:26 am ]
Post subject:  Re: Show statistics now available

Ah, okay, I get what you meant now Jim. :)

Author:  philipgar [ Tue Mar 08, 2011 3:15 am ]
Post subject:  Re: Show statistics now available

Homesick wrote:
dells wrote:
This is an awesome and interesting addition to the site, Thanks!

On the default overall results page, is it possible to provide links to be able to request results based just on the data from the last 10 yrs and last 5 yrs?


It would be possible with some extra work. If there's considerable interest in such a feature, I might take the time to add it.


Actually, I think it would be more useful to put in a start and stop year. Shouldn't be much more work than going from the last 5 years or 10 years, just add an extra qualifier to the SQL count statements. I imagine most of the work was in writing the statement to get the counts of everything and sorting them up nicely. Adding the "WHERE x.year>1990 and x.year<2000" wouldn't be too hard... Just make sure you use a drop down menu and sanitize the inputs (ensure they're only digits). Don't want a little bobby tables incident.

Phil

Author:  Homesick [ Tue Mar 08, 2011 6:46 am ]
Post subject:  Re: Show statistics now available

That's right, Alyssa: while Jim did spend hours on end manually entering all of that data, I deserve all the credit for taking an hour to write those database queries. ;)

I'll do as suggested and put in "start" and "end" textboxes so you can analyze the data in any time period. It should be done in not too long.

Author:  Homesick [ Tue Mar 08, 2011 3:03 pm ]
Post subject:  Re: Show statistics now available

Alright, I've added the ability to look only in a specific time period. Try it out!

Page 1 of 1 All times are UTC - 6 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/