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])
The stat will still count if a player check-calls (and/or check-raises) the flop and turn so you should use
lookup_actions_f.action = 'X' and lookup_actions_t.action = 'X' instead of
cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.flg_t_check AND NOT cash_hand_player_statistics.flg_f_bet AND NOT cash_hand_player_statistics.flg_t_bet.
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...
If you're seeing that error when testing in your code in a custom report then that's a known issue. To workaround that you can change the code in upper case in the expression to lower case (AND -> and) or you can change the number of hands displayed in the report from 'Most Recent 100 Hands' to 'All Hands'.