3/4 bet and allin preflop

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

3/4 bet and allin preflop

Postby lunalucky » Fri Mar 16, 2012 11:00 am

Hi all,
I create this filter: (Preflop3Bet OR Preflop4Bet OR PreflopRaise All-In OR Preflop 4Bet Opportunity and Called OR Call3Bet Preflop OR Call4Bet Preflop OR Facing All-In: Preflop, Called). I want to create the same column in Holdem Cash Player Statistics to count these hands. Help me, please.
Thanks
lunalucky
 
Posts: 3
Joined: Thu Oct 15, 2009 5:54 am

Re: 3/4 bet and allin preflop

Postby kraada » Fri Mar 16, 2012 2:44 pm

sum(if[holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_4bet_opp or holdem_hand_player_statistics.flg_p_3bet_def_opp or holdem_hand_player_statistics.flg_p_4bet_def_opp or holdem_hand_player_statistics.enum_allin = 'P', 1, 0])

Several of your filters overlap so this should count everything without the duplication.
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