4bet vs hero

[Huttydr]

hello again sorry for the inconvenience, now i want to built a 4Bet vs Hero only in 4bet sequence this would be the idea. what that you think?


sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_4bet and char_length(cash_hand_summary.str_aggressors_p) = 4 and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_3bet), 1, 0])

[Flag_Hippo]

Specifying the aggressors string length is only 4 characters using char_length(cash_hand_summary.str_aggressors_p) = 4 will not count the hands when Hero 5Bets. Use >= (Greater Than or Equal) instead.

[Huttydr]

Specifying the aggressors string length is only 4 characters using char_length(cash_hand_summary.str_aggressors_p) = 4 will not count the hands when Hero 5Bets. Use >= (Greater Than or Equal) instead.

OK, I understand thanks!