I neeed this stat in single raised and 3bet pot . So first barel we have by default "fold to flop float bet" but not I want to make call flop float and fold to turn bet. It seems it is working for single raised pot but when I change char_length(cash_hand_summary.str_aggressors_p) = 3 I do not get any output (when testing stat in filter). Here is the code :
sum(if[ not(cash_hand_player_statistics.flg_p_face_raise) AND char_length(cash_hand_summary.str_aggressors_p) = 3 AND lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XC' AND cash_hand_player_statistics.amt_t_bet_facing > 0 AND substring(lookup_actions_t.action from 1 for 2) = 'XF', 1, 0])