Stats Graphs

Discussion about the Geocaching Australia web site
Post Reply
User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 08 September 05 11:28 pm

Good suggestion Damo.
Again a problem in that not everyone who finds caches knows about geocaching.com.au and haven't completed a profile.

It would be interesting to know from i! what the % of cachers vs cachers with this value complete in their profile is.

Ideology. Can you give an indication of whether this is useable enough to warrant an added statspack file for cacher and state?

User avatar
ideology
Posts: 2763
Joined: 28 March 03 4:01 pm
Location: Sydney
Contact:

Post by ideology » 10 September 05 8:33 am

we've produced a new file for you. please see the other thread for details.

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 10 September 05 6:41 pm

Okey dokey.

Thanks to i!, we've incorporated the cachers by state details.

http://www.caughtatwork.net/geocaching/graphs/

All of the Top graphs that appear on the very first page are now viewable by state. Select the state you are interested in from the drop down and click the Submit button.

There is a disclaimer about the quality of data, so if you're not showing up on the graphs and you think you should be, check your forum profile and make sure your state is set correctly.

Enjoy.

User avatar
ideology
Posts: 2763
Joined: 28 March 03 4:01 pm
Location: Sydney
Contact:

Post by ideology » 10 September 05 7:49 pm

great stuff!
is it possible to rotate some of the column graphs into bar graphs to make it easier to read the legends? eg top 50 caches by finds per state

User avatar
setsujoku
3500 or more caches found
3500 or more caches found
Posts: 1422
Joined: 28 December 04 5:46 pm
Twitter: BGNWP
Location: Athelstone, SA
Contact:

Post by setsujoku » 10 September 05 7:54 pm

Thanks C@W, these stats are great, and make for really interesting reading.

<P>It shows how much time i spend caching compared to others in the state, now thats scary!!!</P>

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 10 September 05 10:14 pm

ideology wrote:great stuff!
is it possible to rotate some of the column graphs into bar graphs to make it easier to read the legends? eg top 50 caches by finds per state
Bar graphs? Isn't that where we started?
Just joshing :D
Ask and ye shall receive.
I think I've covered them all off. If you see another, please let me know.

energizer61
300 or more found
300 or more found
Posts: 353
Joined: 25 October 04 5:18 pm
Location: Burnie Tasmania

Post by energizer61 » 10 September 05 10:41 pm

ideology wrote:great stuff!
is it possible to rotate some of the column graphs into bar graphs to make it easier to read the legends? eg top 50 caches by finds per state
lol, & my solution was to turn the monitor on the side, D'oh, why didn't I think to ask.... way to go C@W, excellent stuff.

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 10 September 05 11:01 pm

energizer61 wrote:
ideology wrote:great stuff!
is it possible to rotate some of the column graphs into bar graphs to make it easier to read the legends? eg top 50 caches by finds per state
lol, & my solution was to turn the monitor on the side, D'oh, why didn't I think to ask.... way to go C@W, excellent stuff.
BWHAHAHAHA! :mrgreen:

User avatar
ideology
Posts: 2763
Joined: 28 March 03 4:01 pm
Location: Sydney
Contact:

Post by ideology » 11 September 05 12:00 pm

this is excellent stuff!
if you can make it accept urls like the the following, we can link it up to the cache and cacher pages:
http://whatever/cacher/ideology
http://whatever/caches/au/vic

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 11 September 05 9:30 pm

You are using the rewrite engine (which I'm not) but that shouldn't be neither here nor there. You should still be using the $_GET which you can use to set the parameter value

What I can do is give you the names of each of the graphs. You then call them by using an img tag with the appropriate variables.

eg.
<img src="http://www.caughtatwork.net/geocaching/ ... cachername">

<img src="http://www.caughtatwork.net/geocaching/ ... =statename">

Give me a few days to refine the graph names. I'm not happy with my naming convention, so I think I'll just give them generic names rather than try to be specific about what the graph is for.

That also means I can change the actual graph without having to get you to rename the link.

Of course, I would prefer that we end up with a solution whereby the graphs sit on the GCA website. That way we aren't trying to keep my database up to date with yours. I'll always be a litle behind.

Is there any chance you can set up a MySQL DB on your server? We could then run a CRON job once a day to load the three tables which are currently defined. If I could then get access to, say, caughtatwork.geocaching.com.au we could keep the code and DB in one place, but I could get to it to maintain it.

!mike
Posts: 129
Joined: 03 April 05 1:49 am
Location: Port Noarlunga, South Australia

Post by !mike » 15 September 05 6:54 pm

It is difficult to distinguish between the dark blue and the black used for archived caches.
It it possible to use a lighter blue or totally different colour?

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 15 September 05 7:35 pm

I can choose any color I like.
Is the blue (as per the bubble graph) an OK blue?

!mike
Posts: 129
Joined: 03 April 05 1:49 am
Location: Port Noarlunga, South Australia

Post by !mike » 15 September 05 9:51 pm

That would be fine. I was looking at:
Top 50 caches by DNF: SA
and found difficulty reading it because the "archived" in black did not stand out against the dark blue.

The graphs by the way are fantastic. Keep up the good work.

User avatar
caughtatwork
Posts: 16366
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 15 September 05 10:38 pm

zatbetta?

!mike
Posts: 129
Joined: 03 April 05 1:49 am
Location: Port Noarlunga, South Australia

Post by !mike » 15 September 05 10:44 pm

Much better. Thanks.

Post Reply