Fold to Turn Float in 3Bet Pot

[L0KI]

Hi, need stat Fold to Turn Float in 3Bet Pot, I changed from Fold to Flop Float in 3Bet Pot, all right?

(cnt_f_float_def_opp_action_fold_3bet_pot_copy / cnt_f_float_def_opp_3bet_pot_copy) * 100


sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_t_open_opp AND cash_hand_player_statistics.amt_t_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XF', 1, 0]) this is cnt_f_float_def_opp_action_fold_3bet_pot_copy

sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_t_open_opp AND cash_hand_player_statistics.flg_t_check AND cash_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
this is cnt_f_float_def_opp_3bet_pot_copy.

I am changed in the second third line _f_ on the _t_.

[kraada]

For the turn and river there are built in columns: cash_hand_player_statistics.flg_t_float_def_opp which says you faced a turn float (and flg_r_float_def_opp is for the river). These will simplify your expression - just keep the 3bet or 4bet bit then check this and that should give you what you need.

If you want to keep what you have though you'll want to change lookup_actions_f to lookup_actions_t.