Comparing Stats Reports

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

Comparing Stats Reports

Postby puyanwei » Wed Oct 21, 2009 8:33 am

Hi,

I want to compare the stats that I have playing sngs on different days/weeks/months. I also want to create a report comparing the stats that my opponents (that I have more then 500 hands on, filter out the rest) have.

I already have reports looking at my results, and stats, but since the date column is in a different section (tournament results),I cant combine the two.

Thanks
puyanwei
 
Posts: 37
Joined: Wed Oct 21, 2009 8:25 am

Re: Comparing Stats Reports

Postby kraada » Wed Oct 21, 2009 9:36 am

There will be more filters coming to help with this sort of thing, but if you could be a bit more specific about what time frames you want to narrow things down to I'd be happy to help you create the report you're looking for.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Comparing Stats Reports

Postby puyanwei » Wed Oct 21, 2009 9:29 pm

Time frames? I don't really understand what you mean sorry.

For example it would be useful to see my stats (vpip, pfr, etc) and compare on a daily/weekly/monthly basis. Using them to compare the optimal stats for winning sessions.

I'd like to do the same thing for other players too, comparing their stats to each other and mine, on certain days/weeks/months. But only have the regular's stats, so that I can adjust my play against them.
puyanwei
 
Posts: 37
Joined: Wed Oct 21, 2009 8:25 am

Re: Comparing Stats Reports

Postby WhiteRider » Thu Oct 22, 2009 4:32 am

Have a look at the Reports section of the Repository for some example reports of this kind that I uploaded.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests