Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
CaioCapT wrote:How can I build this stat for tourneys: Fold to F cbet after preflop limp/call?
sum(if[tourney_hand_player_statistics.flg_p_open_opp and lookup_actions_p.action = 'CC' and tourney_hand_player_statistics.enum_f_cbet_action='F', 1, 0])
sum(if[tourney_hand_player_statistics.cnt_players = 2
and tourney_hand_player_statistics.flg_p_open_opp
and lookup_actions_p.action = 'CC'
and char_length(tourney_hand_summary.str_aggressors_t) >= 1
and lookup_actions_f.action = 'X'
and tourney_hand_player_statistics.amt_t_bet_facing > 0
and substring(tourney_hand_summary.str_aggressors_t from 1 for 1)::int = substring(tourney_hand_summary.str_aggressors_p from '.$')::int
and lookup_actions_t.action SIMILAR TO '(F|XF)%', 1, 0])
sum(if[tourney_hand_player_statistics.cnt_players = 2
and lookup_actions_p.action = 'CC'
and lookup_actions_f.action = 'X'
and lookup_actions_t.action = 'F', 1, 0])
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 36 guests