Stats Graphs
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
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?
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?
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
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.
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.
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
Bar graphs? Isn't that where we started?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
Just joshing
Ask and ye shall receive.
I think I've covered them all off. If you see another, please let me know.
-
- 300 or more found
- Posts: 353
- Joined: 25 October 04 5:18 pm
- Location: Burnie Tasmania
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
BWHAHAHAHA!energizer61 wrote: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.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
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
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
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
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.
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.
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
- caughtatwork
- Posts: 17016
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact: