by dave2085 » Tue Apr 10, 2018 9:09 am
are these expressions correct to filter for this stat: SB limps, BB checks, SB check, BB bets and SB Folds.
sum(if[tourney_hand_player_statistics.flg_blind_s and tourney_hand_player_statistics.flg_p_limp
AND NOT(tourney_hand_player_statistics.flg_p_face_raise)
AND tourney_hand_summary.str_aggressors_p NOT LIKE '89%'
and tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'XF' , 1, 0])
this expression for when the SB checks the flop in these situations:
sum(if[tourney_hand_player_statistics.flg_blind_s and tourney_hand_player_statistics.flg_p_limp
AND NOT(tourney_hand_player_statistics.flg_p_face_raise)
AND tourney_hand_summary.str_aggressors_p NOT LIKE '89%'
and tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.flg_f_check
AND tourney_hand_player_statistics.amt_f_bet_facing > 0 , 1, 0])