griffith_white wrote:I think I understand because lookup_actions_p.action ='RF' than player raise folded and if he was the initial raiser than it would be 'RRF' ?
That is correct.
griffith_white wrote:Also I am confused why are we using cash_hand_player_statistics.enum_p_3bet_action='R' instead of flg_p_4bet ? Isnt that a same thing ?
Given everything available in the database schema there is usually more than one way to build a custom statistic however while raising a 3bet and 4betting are the same thing in poker terms it's not necessarily the same in the PokerTracker 4 database schema.
cash_hand_player_statistics.flg_p_4bet is true if a player 4bets
or higher.
griffith_white wrote:I manage to make it on different way. The values seems correct. Is this also fine ?
sum(if[char_length(cash_hand_summary.str_aggressors_p) > 4 AND NOT(cash_hand_player_statistics.flg_p_first_raise) and cash_hand_player_statistics.position = substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and cash_hand_player_statistics.flg_p_fold, 1, 0])
With your expression I am seeing a few more hands which are not cold 4bets e.g. when a player calls a 2bet and then back raises with a 4bet this gets counted.