whiterider's time into session stat

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

whiterider's time into session stat

Postby pepsin » Thu Oct 20, 2011 8:34 pm

I recently downloaded whiterider's time into session (stats + report) and find this potentially very useful. I'm not really into custom stats and such, but it seems to me this stat treats sessions "by table" and not "by time" (as differentiated in the "sessions" tab) as I have several sessions by time that are longer than the longest time covered when running the report. I think this stat would be more useful if it treated sessions "by time" as it would really track one's progression through the hours.. Is this possible?
pepsin
 
Posts: 207
Joined: Fri Jan 25, 2008 7:01 pm

Re: whiterider's time into session stat

Postby WhiteRider » Fri Oct 21, 2011 3:26 am

That isn't really possible with the mechanism I used. The data is stored in the database by table session (which is what custom stats use) and the Sessions by Time has some extra structure behind it to group the overlapping sessions.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: whiterider's time into session stat

Postby pepsin » Fri Oct 21, 2011 5:55 am

Ok, do you think it's possible to make this stat some other way? I'd really find it useful as it would tell me how I play when I'm tired etcetc..
pepsin
 
Posts: 207
Joined: Fri Jan 25, 2008 7:01 pm

Re: whiterider's time into session stat

Postby kraada » Fri Oct 21, 2011 8:11 am

Unfortunately it isn't as you'd need to loop over the results before you can group the sessions by time.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests