filter out cold4bets

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

filter out cold4bets

Postby maggu5 » Tue Nov 14, 2023 8:40 pm

Would appreciate help to remove cold4bets in this stat. Also open to ideas to do the same via Tournament filters

Ncold4bet.png
maggu5
 
Posts: 8
Joined: Tue Oct 22, 2013 7:53 pm

Re: filter out cold4bets

Postby maggu5 » Wed Nov 15, 2023 1:01 am

Could there be a way to alternate this one

cold4bet.png
maggu5
 
Posts: 8
Joined: Tue Oct 22, 2013 7:53 pm

Re: filter out cold4bets

Postby maggu5 » Wed Nov 15, 2023 2:02 am

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:
maggu5
 
Posts: 8
Joined: Tue Oct 22, 2013 7:53 pm

Re: filter out cold4bets

Postby Flag_Hippo » Thu Nov 16, 2023 9:14 am

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.
Flag_Hippo
Moderator
 
Posts: 14482
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 4 guests

cron
highfalutin