Page 1 of 1

filter out cold4bets

PostPosted: Tue Nov 14, 2023 8:40 pm
by maggu5
Would appreciate help to remove cold4bets in this stat. Also open to ideas to do the same via Tournament filters

Ncold4bet.png
(66.6 KiB) Downloaded 3729 times

Re: filter out cold4bets

PostPosted: Wed Nov 15, 2023 1:01 am
by maggu5
Could there be a way to alternate this one

cold4bet.png
(105.58 KiB) Downloaded 3675 times

Re: filter out cold4bets

PostPosted: Wed Nov 15, 2023 2:02 am
by maggu5
sum(if[ char_length(tourney_hand_summary.str_aggressors_p) >= 4 AND substring(tourney_hand_summary.str_aggressors_p from 4 for 1)::int = substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int AND tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

:heart:

Re: filter out cold4bets

PostPosted: Thu Nov 16, 2023 9:14 am
by Flag_Hippo
Code: Select all
char_length(tourney_hand_summary.str_aggressors_p) >= 4 AND substring(tourney_hand_summary.str_aggressors_p from 4 for 1)::int = substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int

That's correct. This means that the player who made the 4bet also made the 2bet so it wouldn't include cold 4bets. For more information this post has information on how the actors and aggressors strings work while this thread and this thread discuss how you can compare/test the strings.