Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
-
maggu5
-
- Posts: 16
- Joined: Tue Oct 22, 2013 7:53 pm
by maggu5 » Wed Nov 15, 2023 1:01 am
Could there be a way to alternate this one
-
maggu5
-
- Posts: 16
- Joined: Tue Oct 22, 2013 7:53 pm
by 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: 16
- Joined: Tue Oct 22, 2013 7:53 pm
by 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: 17044
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 40 guests