Stats Graphs

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?

ideology · Post by **ideology** » 10 September 05 8:33 am

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

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.

ideology · 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

setsujoku · 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>

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

Ask and ye shall receive.
I think I've covered them all off. If you see another, please let me know.

energizer61 · 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.

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!

ideology · 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

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 · 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?

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 · 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.

Post by **caughtatwork** » 15 September 05 10:38 pm

zatbetta?

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

Much better. Thanks.