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
by gman » Fri Oct 03, 2008 5:21 am
I'm trying to create a report that shows how often I won in a showdown when I 3bet the flop.
This did work with the raise expression:
- Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])
- Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand, 1, 0])
But this doesn't work:
- Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_3bet > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])
- Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_3bet> 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand, 1, 0])
I want to do :
- Code: Select all
(cnt_f_3bet_wtsd_won / cnt_f_3bet_wtsd) * 100
WHere am I falling down. Any help is appreciated. Thanks.
-
gman
-
- Posts: 6
- Joined: Fri Oct 03, 2008 4:59 am
by WhiteRider » Fri Oct 03, 2008 12:15 pm
holdem_hand_player_statistics.cnt_f_3bet doesn't exist - it is:
holdem_hand_player_statistics.flg_f_3bet
You can only 3bet once on the flop, so there is no need for a cnt_ (count) stat, it is just a flg_ (flag/boolean) stat.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 2 guests