Filtering

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

Filtering

Postby pokerjim » Mon May 10, 2010 2:19 am

Is it possible to filter so that on the summary page I only see players that have played more than 500 hands?

I'd also like to see, for example, when a player raises UTG how often does everyone else fold? Can this be done?
pokerjim
 
Posts: 12
Joined: Sun Mar 09, 2008 8:17 pm

Re: Filtering

Postby kraada » Mon May 10, 2010 9:22 am

Filtering the Summary tab like that is not possible but if you click the Hands column PT3 will sort by that value so you can see all of the players sorted by number of hands played if you wanted to see who you had a lot of data on.

For your other question you could do this with a custom report and filters.

You'd want to filter for position of UTG (depending on what size games you play that will vary), Actions -> Raise -> Raise First In, Facing -> Preflop -> Facing Raise then Not it so you have NOT(Facing Raise), Actions -> Flop -> Saw Flop, and NOT() that as well, then add Misc -> Results ->Won Hand. Then you raised first in UTG, didn't face a re-raise, didn't see a flop, and won the hand - the only way that can happen is if your raise was uncontested.

Make a note of how many times that happened. Then compare that to a filter of just being UTG and raising first in, and you can figure out what percentage of those raises won without any fight from your opponents.
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 3 guests