Hi, im having trouble creating the second column, the 3B_opp stat for when BU MR-2.5x, SB F, BB 3B
BB 3B vs BU MR2.5x
(cnt_p_3bet_BB_BUMR2.5x / cnt_p_3bet_opp_BB_BUMR2.5x)*100
sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.str_actors_p LIKE '08%' and ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) between 2 and 2.5 and tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.flg_p_3bet_opp and NOT (tourney_hand_player_statistics.flg_p_limp), 1, 0])
This captures the hands where BU MR-2.5x, SB F, and BB calls or 3Bets, but the times when the BB folds, this is also a 3B opp so im trying to figure out an expression that includes that also, but im having trouble.
If you use tourney_hand_summary.str_actors_p LIKE '0', this captures it, but what expression can i use/add so that it captures all 3 scenarios (BB fold, BB call, BB 3Bets, since as long as it is folded to the BB it is a 3bet opportunity)
Merry Christmas everybody!