hi there , i want to create custom stats, which would show opponent fold versus my (HERO) izo in big blinds in certain effective stack ranges . for example eff stack is 11 big blinds. oponent limps (1bb , 0.5 was already put and he/she add another 0.5, to make it 1) and i raise him/her to 3 big blinds in total. (he/she has to add 2 more for example) and he/she folds. how can i achieve that? another example is the same, but i raise to 4.5 big blinds (he/she has to add 3.5 more) where effective stack is 17 big blinds, third example i raise to 7x (he/she has to add 6 big blinds more), eff stack 23 big blinds.
i would believe that the formule could look like this:
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10.9 and 11 AND (tourney_hand_player_statistics.amt_p_2bet_facing < (tourney_blinds.amt_bb * 3)), 1, 0])
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 16.9 and 17 AND (tourney_hand_player_statistics.amt_p_2bet_facing < (tourney_blinds.amt_bb * 4.5)), 1, 0])
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 22.9 and 23 AND (tourney_hand_player_statistics.amt_p_2bet_facing < (tourney_blinds.amt_bb * 7)), 1, 0])
is that correct or how should I change it? I am not sure if i should use "<" sign after 2bet_facing (thought i should use equals sign, but therefore I need an explanation)