StarsIsRigged wrote:I want to check how often someone donk bets the river when the action for both player was:
check Flop and check Turn, Villain donk River. If that works then I want to make it so that I can see also a percentage.
This is my code for now:
sum(if[cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.flg_t_check AND cash_hand_player_statistics.flg_r_bet AND NOT cash_hand_player_statistics.flg_f_bet AND NOT cash_hand_player_statistics.flg_t_bet, 1, 0])
StarsIsRigged wrote:But I get this error message:
Error: Unable to execute query: Fatal Reason Error: (Error: syntax error at or near")" LINE 1: ..._hand_player_statistics.id_holecard)=166))AND(((() >= 1))A...
(Check_Flop_Turn_and_Donk_River / Check_Flop_Turn_River)*100
sum(if[lookup_actions_f.action='X' and lookup_actions_t.action='X' and cash_hand_player_statistics.flg_r_bet,1,0])
sum(if[lookup_actions_f.action='X' and lookup_actions_t.action='X' and lookup_actions_r.action='X',1,0])
sum(if[lookup_actions_f.action='X' and lookup_actions_t.action='X' and cash_hand_player_statistics.flg_r_open_opp,1,0])
Users browsing this forum: Google [Bot] and 3 guests