Report filter: Only players in another filter

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

Report filter: Only players in another filter

Postby Filterun » Mon May 23, 2011 4:42 am

I have a report that (I think) narrows down a list of all players to only players who are fish.

I want, using this report, to run a player cash stastic report that looks at the stats of people who fit the original report. This way I can look at, say, how often a fish c/r flop, as opposed to how often an average player c/r a flop.

Is this possible?

Thanks for any help.
Filterun
 
Posts: 7
Joined: Wed Apr 14, 2010 9:25 pm

Re: Report filter: Only players in another filter

Postby kraada » Mon May 23, 2011 8:22 am

This is certainly possible. How exactly are you defining "fish"?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report filter: Only players in another filter

Postby Filterun » Tue May 24, 2011 12:30 am

kraada wrote:This is certainly possible. How exactly are you defining "fish"?


I have a holdem cash player statistic report that only chooses players who have:

cnt_p_limp > 1
#Hands# > 15

My simple filters are:

NOT(Position = 4)
With six players.

The only statistic in the report is Player.

This (roughly) gives me a list of players who seem fishy.
Filterun
 
Posts: 7
Joined: Wed Apr 14, 2010 9:25 pm

Re: Report filter: Only players in another filter

Postby kraada » Tue May 24, 2011 8:36 am

All you need to do is add the statistic "Check Raise Flop" to the report - then you'll see how often those players check raise the flop. Though you may want to consider removing the not(position = 4) bit as then you're pulling out early position spots where they might be more inclined to check and then raise.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report filter: Only players in another filter

Postby Filterun » Tue May 24, 2011 8:56 am

kraada wrote:All you need to do is add the statistic "Check Raise Flop" to the report - then you'll see how often those players check raise the flop. Though you may want to consider removing the not(position = 4) bit as then you're pulling out early position spots where they might be more inclined to check and then raise.


Sorry - by C/R flop I meant something more complex; C/R turn after c/r'ing the flop and checking the turn in a single raised pot. I hope to be able to use it for other complex stats like that to.
Filterun
 
Posts: 7
Joined: Wed Apr 14, 2010 9:25 pm

Re: Report filter: Only players in another filter

Postby kraada » Tue May 24, 2011 9:45 am

In that case, add a simple filter for check flop and any raise (flop) and add the check raise turn stat.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report filter: Only players in another filter

Postby Filterun » Tue May 24, 2011 10:08 am

Ah, thats way easier to do than I realized, thank you.
Filterun
 
Posts: 7
Joined: Wed Apr 14, 2010 9:25 pm

Re: Report filter: Only players in another filter

Postby kraada » Tue May 24, 2011 10:39 am

You're welcome. Feel free to play with it - if there's other scenarios you're having trouble with let me know and I'll help you get those set up too.
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 0 guests