DJSpinThat wrote:i think i got the others, just wanted to make sure if the following looks correct?
sum(if[tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb <=4 and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and tourney_hand_player_statistics.flg_p_limp, 1, 0])
If this is also for the SB then you haven't specified that here. Also when a player limps and another player raises to 4bb then the limper is facing a 2Bet of 3bb since that is the amount they now need to call. If you use 4bb then it will count hands where the 2Bet is 5BB. Finally since you are using <= then hands will get counted when amt_p_2bet_facing / tourney_blinds.amt_bb is zero and in these columns you don't want to count hands where the player didn't face a raise after limping.