Hero stats report per date ranges

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

Hero stats report per date ranges

Postby tiako » Wed Jan 07, 2009 11:44 am

Hi,

I'm trying to analyze variation in my play that could affect to my good or bad runs.
Is there any way to create a report that shows player stats per date ranges? For example I would like to know my vpip, pfr, cbet%, etc... in a report with one row per week during the last three months.
If this is not posible, could it be possible to have a extended session report with player stats, i.e., not only have winning, minutes of play, etc..., but also vpip, pfr, etc.

Thanks.
tiako
 
Posts: 29
Joined: Wed Feb 06, 2008 6:29 pm

Re: Hero stats report per date ranges

Postby kraada » Wed Jan 07, 2009 12:00 pm

The stats information you want can't be added to the sessions report at this time.

You could, I think, do what you want as a custom report, but I'm not 100% fluent with the PostgreSQL date functions which I think you'd need to use to create a few stats first. See this thread for more about how to use the PostgreSQL date and time functions.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hero stats report per date ranges

Postby tiako » Wed Jan 07, 2009 1:57 pm

Hi,

Sorry, which thread do you mean?

Thanks
tiako
 
Posts: 29
Joined: Wed Feb 06, 2008 6:29 pm

Re: Hero stats report per date ranges

Postby kraada » Wed Jan 07, 2009 3:42 pm

The words "this thread" were a link; click on that link and it'll take you directly to the thread I was talking about.
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 1 guest