hola necesito ayuda para hacer una stats para spin and go ,que cuente % de veces que en 3h button fold ,SB hace OR < a 3.5bb, BB call ,cbet flop,BB call ,en turn check check,y riber SB betea ...intente hacerlo de esta manera pero no funciona
(bet_x_bet_SBvsBB / bet_x_bet_oop_SBvsBB) * 100
bet_x_bet_SBvsBB
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet_opp
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0)
AND tourney_hand_player_statistics.flg_r_bet, 1, 0])
bet_x_bet_oop_SBvsBB
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet_opp
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0), 1, 0])