These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE General Discussion

 
  • Topic is locked indefinitely.
 

Please Explain
Author
Previous Topic Next Topic
Tippia
Sunshine and Lollipops
#61 - 2012-07-12 11:41:37 UTC
Chribba wrote:
Someone help me write a better function to graph the charts properly Lol

/c
For the “last week” and maybe “last month” graphs, only show peak numbers (or pick three “representative” hours in the day and graph them as their own lines) to reduce the noise.

For the “last n months” (including “last year”) show only peak numbers and further separate the numbers by day — each day with on its own line. Same with the all-time averages.

Chart from left to right — newest numbers on the right.
Tyreul Severasse
#62 - 2012-07-12 12:12:01 UTC
Chribba wrote:
Someone help me write a better function to graph the charts properly Lol

/c

Maybe just make note that the graphs are "backwards" and that you can get additional info by mousing over.
Renan Ruivo
Forcas armadas
Brave Collective
#63 - 2012-07-12 12:36:00 UTC
65535th post saying the same thing everyone else has been saying. Just because.

The world is a community of idiots doing a series of things until it explodes and we all die.
Azami Nevinyrall
172.0.0.1
#64 - 2012-07-12 12:41:42 UTC
Flip a coin...

Heads - Summer (boobs)
Tails - You read it backwards

...
Chribba
Otherworld Enterprises
Otherworld Empire
#65 - 2012-07-12 13:48:08 UTC
Tippia wrote:
Chribba wrote:
Someone help me write a better function to graph the charts properly Lol

/c
For the “last week” and maybe “last month” graphs, only show peak numbers (or pick three “representative” hours in the day and graph them as their own lines) to reduce the noise.

For the “last n months” (including “last year”) show only peak numbers and further separate the numbers by day — each day with on its own line. Same with the all-time averages.

Chart from left to right — newest numbers on the right.


Can you write that SQL query that will pull all data and sort them accordingly? Haha that is actually the biggest issue, having a really good query that will do most of the sum/avg/presentation for me, since the data in the db is not linear in terms of always 1440 measure points per day etc

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
Kyle Ward
Doomheim
#66 - 2012-07-12 13:58:17 UTC
I tried to quit EVE once 'cause it's a bad game.

For some reason I'm still here though...

The Sandbox, you're playing it wrong!
Andoria Thara
Fallen Avatars
#67 - 2012-07-12 14:07:46 UTC
Chribba wrote:
Tippia wrote:
Chribba wrote:
Someone help me write a better function to graph the charts properly Lol

/c
For the “last week” and maybe “last month” graphs, only show peak numbers (or pick three “representative” hours in the day and graph them as their own lines) to reduce the noise.

For the “last n months” (including “last year”) show only peak numbers and further separate the numbers by day — each day with on its own line. Same with the all-time averages.

Chart from left to right — newest numbers on the right.


Can you write that SQL query that will pull all data and sort them accordingly? Haha that is actually the biggest issue, having a really good query that will do most of the sum/avg/presentation for me, since the data in the db is not linear in terms of always 1440 measure points per day etc



If you want to PM me the current SQL query that you're using, I can help you sort it out (if Tippia hasn't gotten with you on it)
Zyress
Caldari Provisions
Caldari State
#68 - 2012-07-12 14:09:19 UTC  |  Edited by: Zyress
Kyle Ward wrote:
I tried to quit EVE once 'cause it's a bad game.

For some reason I'm still here though...



Its a sickness, you have too much time invested to quit now. The Skill Points must flow. That and there's no alternative Space ship flying mmo.
Tippia
Sunshine and Lollipops
#69 - 2012-07-12 14:20:33 UTC
Chribba wrote:
Can you write that SQL query that will pull all data and sort them accordingly? Haha that is actually the biggest issue, having a really good query that will do most of the sum/avg/presentation for me, since the data in the db is not linear in terms of always 1440 measure points per day etc
Hmm… The way I'd approach it would probably be a dual-layered approach: one that just shoves the API data into the DB for the daily graph(s), and another that, at strategically chosen times, runs the “max today” query and stores that in a separate table with the date and even the day as a key-value enum. Then pull numbers from that table for the longer-term graphs.

…but it's been ages since I fiddled with SQL so they might have added calls that would do that without having to store the additional data.
Andoria Thara
Fallen Avatars
#70 - 2012-07-12 14:28:23 UTC
I did something similar for D&D:Online back when I used to play it, grabbed the login statistics from the login server and dumped the data into a SQL db.

http://i292.photobucket.com/albums/mm34/stevoli/3-5-2010-1.png
Lin-Young Borovskova
Doomheim
#71 - 2012-07-12 14:31:41 UTC
baltec1 wrote:
Not Amused Responsible wrote:



pretentious dribble, this is Eve; its not SWG, not the same Aminal.


No, EVE is in far far better shape than many other MMOs, a lot of them new. WoW has bled what? a million subs in the last year? STO forced to go FTP after its numbers collapsed, TOR bleeding subs at a shocking rate.

Compared to all of these EVE is positivly thriving.



Hope some of those get around, fresh canon meat it's always good for the game.

brb
Forum Foreplay
#72 - 2012-07-12 15:49:12 UTC
This is like the forth thread on this website.

It is backwards.

Even a sandbox has borders to keep the sand inside...
Mr Beardsley
Royal Amarr Institute
Amarr Empire
#73 - 2012-07-12 17:24:17 UTC
Zyress wrote:
Kyle Ward wrote:
I tried to quit EVE once 'cause it's a bad game.

For some reason I'm still here though...



Its a sickness, you have too much time invested to quit now. The Skill Points must flow. That and there's no alternative Space ship flying mmo.


Sadly true. I would love a piece of the fortune that will be made from an EVE-like game that actually fixes bugs and makes the game accessible to all playstyles.
Chribba
Otherworld Enterprises
Otherworld Empire
#74 - 2012-07-13 09:19:23 UTC
I'm trying to reduce the number of calls needed to graph it all.

Basically it's just a table with


timestamp | players
2012-07-13 11:11:11 | 8372
2012-07-13 11:12:23 | 8379

etc. Problem being that the timestamp is not countinous in terms of minutes, sometimes it can be 1m2s between the time sometimes 1m30s and so on, so I can't just grab the top 1440 rows for a day and expect it to graph out nicely.

Same goes for when there is longer periods, I could star running many queries to get the best values but I'd like to try have it in less queries. Hence the jumpyness in some graphs as it grabs values here and there that may be higher than the previous since it's just one sample out of many

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
Nazowa
Center for Advanced Studies
Gallente Federation
#75 - 2012-07-13 10:18:05 UTC
The moment Guild Wars 2 is out you can scratch SWTOR. Even diehard fans of Star Wars are beginning to shun it finally. How can such a franchaise fail two times in a row simply boggles me.
Darek Castigatus
Immortalis Inc.
Shadow Cartel
#76 - 2012-07-17 08:07:52 UTC
Simple, they copied the Wow formula then left out the one thing which makes it work (a rolling endgame which effectively never ends as long as you dont mind doing the same **** over and over again)

Theres only so many times a personal story remains interesting after all.

Pirates - The Invisible Fist of Darwin

you're welcome
Chribba
Otherworld Enterprises
Otherworld Empire
#77 - 2012-07-19 13:27:16 UTC
For your pleasure, the graphs have now been switched (and new code implemented giving me a better way of generating intervals).

/c

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
Kyle Ward
Doomheim
#78 - 2012-07-19 14:06:32 UTC
Anyone else read the thread title and hear the ST: Voyager ship computer say "Please Specify?"?




...Really, just me?

The Sandbox, you're playing it wrong!
Karkaroph
Imperial Academy
Amarr Empire
#79 - 2012-07-19 14:48:48 UTC
I seem to be posting this a lot today.


If fits so many topics. It seems sentimentalism is always in style.



http://www.chicasperdidas.shivtr.com/videos/53269


10 years you say?

[i]I have seen so much of it, that truly I know nothing of it, except that it embaces me.

I, Karkaroph.[/i]