ICSTBIYE wrote:Not sure I follow you on the HUD. If I just create a positional popup for the Fold to 3bet %, isn't it just going to be the overall stat by position?
Create the columns/statistics for the positions where the 3Bets are coming from and you can then edit those in the HUD Profile editor or add them to a positional popup to add positional information for the other player.
ICSTBIYE wrote:I'm getting invalid SQL statements.
Could you tell me exactly what the column expressions need to look like?
They need to be inside a
sum(if[, 1, 0]) statement which you seem to have figured out now.
ICSTBIYE wrote:Tried something else that I found. Why don't these statements work (CO fold to BTN 3bet)?
cnt_p_3bet_def_action_fold_btn_vs_co_open- Code: Select all
sum(if[cash_hand_player_statistics.flg_p_2bet and cash_hand_summary.str_aggressors_p LIKE '810%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.position = 1 and cash_hand_player_statistics.enum_p_3bet_action = 'F', 1, 0])
You have added
cash_hand_player_statistics.flg_p_2bet but that doesn't exist in the PokerTracker 4 database schema. If a player makes the first raise in a hand then
cash_hand_player_statistics.flg_p_first_raise is true but something like that isn't required here anyway because this expression already includes the position of the player which matches the second character in the aggressors string therefore they must have been the 2bettor.