I was building a general fold to second barrel stat. Meaning how often player just calls flop and then folds to turn bet. Like this:
(lookup_actions_f.action='C' or lookup_actions_f.action='XC') and holdem_hand_player_detail.amt_t_bet_facing > 0 and (lookup_actions_t.action='F' or lookup_actions_t.action='XF') / (lookup_actions_f.action='C' or lookup_actions_f.action='XC') and holdem_hand_player_detail.amt_t_bet_facing > 0
And I tried to compare it to Fold to turn CBet. I thought that fold to turn CBet would be a subset of this stat but it turns out it isnt. So far it looks like holdem_hand_player_statistics.flg_t_cbet_def_opp are those cases where player just faced a flop cbet and not only called it. So if player raises a flop CBet he still faces a turn Cbet if the same player bets him on turn.
When I ran a custom report on myself I noticed that (holdem_hand_player_statistics.flg_f_cbet_def_opp and holdem_hand_player_statistics.enum_t_cbet_action='F') = holdem_hand_player_statistics.enum_t_cbet_action='F' Meaning both sum up the same number, but that (holdem_hand_player_statistics.enum_f_cbet_action='C' and holdem_hand_player_statistics.enum_t_cbet_action='F') differs from both. With opportunities holdem_hand_player_statistics.flg_t_cbet_def_opp was one more then (holdem_hand_player_statistics.flg_f_cbet_def_opp and holdem_hand_player_statistics.flg_t_cbet_def_opp) with the former being 696 and the latter 695. I dont know why there is one case difference but the folds are identical. I havent testet the river stats yet. So is the following correct:
face flop CBet = pf final action is call a raise and on flop face a bet from the preflop raiser
face turn CBet = face flop CBet and face a bet from the flop CBetter
face river CBet = face turn CBet and face a bet from the turn CBetter
Flop CBet = preflop last raise and flop bet
Turn Cbet = flop cbet and turn bet
River CBet = turn CBet and river bet
