3bet ratio relative to 2bet size

[Greyworm10]

Hi guys!! I dont know if i'm getting an issue or i'm doing something wrong.
I’ve been trying to create a HUD stat to identify betting patterns related to 3-bets (in order to cross-reference this data with NoteCaddy; this will work fine vs fishes, i guess). NoteCaddy is working fine, but my stats aren't. I’ve never run into this issue before. Plus, the architecture is simple—nothing complex. Here is my column:

sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ( cash_hand_player_statistics.amt_p_raise_made / cash_hand_player_statistics.amt_p_2bet_facing ) > '2.8' AND ( cash_hand_player_statistics.amt_p_raise_made / cash_hand_player_statistics.amt_p_2bet_facing ) <= '3.8', 1, 0])

Basically, what I'm trying to do is create a stat that categorizes 3-bets based on their size relative to the open raise, as you can see. I started with SB vs. BB, but the problem is that something isn't working right. If I open to 2.44bb and my opponent 3-bets to 8.88bb (a ratio of 3.63), the program assigns this 3-bet to this other column:

sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ( cash_hand_player_statistics.amt_p_raise_made / cash_hand_player_statistics.amt_p_2bet_facing ) > '4.8', 1, 0])

Why is this happening? Am I making a mistake (highly likely, given that it’s been a while since I created custom statistics), or is something wrong?

Thanks for your work!!

[Greyworm10]

Hi everyone.
I think I’ve found the problem: my definition of "raise" is incorrect. I assume the raise is relative to the previous bets; so, in the SB vs. BB scenario—to get a ratio of 8.88 / 2.44—the numerator must include the raise made (in this case, 6.44; correct me if I'm wrong), the 2bet facing (the amount needed to call, 1.44), and the big blind. Therefore, the denominator should consist of the 2bet facing and the big blind.
Is that correct?

[Greyworm10]

Solved. The raise made is the total amount of the raise (12bb) and the 2bet facing is the cost of the call, so the amount of the big blind must be added to this.

ty anyways!!