hola necesito ayuda para hacer una stats para spin and go ,la stats seria % de veces que en 3h, BB foldea a una bet de BU en river luego de haber pagado la apuesta de BU en flop y turn en un pozo limpeado ,SB fold preflop...........la stats la escribi de la siguiente manera
(cnt_r_cbet_def_action_fold_BBvsBU_LP / cnt_r_cbet_def_opp_BBvsBU_LP) * 100
cnt_r_cbet_def_action_fold_BBvsBU_LP
sum(if[tourney_hand_player_statistics.position=8
AND tourney_hand_summary.str_actors_p = '0'
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0
AND NOT(tourney_hand_player_statistics.flg_p_first_raise)
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND lookup_actions_r.action = 'F', 1, 0])
cnt_r_cbet_def_opp_BBvsBU_LP
sum(if[tourney_hand_player_statistics.position=8
AND tourney_hand_summary.str_actors_p = '0'
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0
AND NOT(tourney_hand_player_statistics.flg_p_first_raise)
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND tourney_hand_player_statistics.amt_r_bet_facing > 0, 1, 0])
no necesito aclarar que hay 3 jugadores ya que este hud esta configurado solo para ser visible en 3H