Hello,
I am trying to build a stat where BB calls BTN open shove.
I use as an example the stat where BB calls SB preflop open shove:
BB call SB preflop open shove = ( cnt_p_BB_call_SB_openshove / cnt_p_BB_face_SB_openshove ) * 100
where "cnt_p_BB_call_SB_openshove" column expression is:
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])
and "cnt_p_BB_face_SB_openshove" expression is:
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])
The result from "BB call SB preflop open shove" is correct, however when I try to change the SB position with BTN position (from 9 to 0), the result is no longer correct.
Can someone take a look and try to find out what is wrong
Thank you
