Check back flop count stat

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

Check back flop count stat

Postby gamiel » Tue Sep 16, 2008 9:35 am

Hi,

I am having trouble creating a statistic that counts the number of times a player checked back the flop/turn/river ie. checked when last to act. Any ideas on how to do this?

Thanks,
David
gamiel
 
Posts: 1
Joined: Sun Jun 15, 2008 7:37 am

Re: Check back flop count stat

Postby WhiteRider » Tue Sep 16, 2008 12:47 pm

I think all you will need are fields like these:
holdem_hand_player_statistics.flg_f_check
holdem_hand_player_detail.flg_f_has_position

So the Column would be
cnt_f_check_behind =
sum( if[ holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_detail.flg_f_has_position, 1, 0] )

You will also want a denominator Column to divide by.
cnt_f_check_behind_opp =
sum( if[ holdem_hand_player_detail.flg_f_open_opp AND holdem_hand_player_detail.flg_f_has_position, 1, 0] )

Then your stat's value expression will be:
( cnt_f_check_behind / cnt_f_check_behind_opp ) * 100

Custom Statistics and Reports FAQ.
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 1 guest