Stuck in stat making process

[Gster]

I'm having some difficulty making this one...

Description:The amount of times the player folded to a 4-Bet preflop after the player made a 3-Bet preflop over
the amount of times the player had the opportunity to fold to a 4-Bet preflop after the player made a 3-Bet preflop.

( cnt_p_4bet_def_action_fold_after_3bet / cnt_p_4bet_def_after_3bet_opp )

I have 2 custom columns

1) cnt_p_4bet_def_action_fold_after_3bet

sum(if[ (holdem_hand_player_statistics.enum_p_4bet_action='F') AND (player made a 3-bet preflop) , 1, 0])

2) cnt_p_4bet_def_after_3bet_opp

sum(if[ (holdem_hand_player_statistics.flg_p_4bet_def_opp) AND (player made a 3-bet preflop) , 1, 0])

First of all would this expression match the description? and if so how do you get an for (player made a 3-bet preflop)?

[WhiteRider]

That looks good, and the database field you're looking for is "holdem_hand_player_statistics.flg_p_3bet".

To find things like this you can look at the existing stats - for instance in this case the built-in stat "3Bet Preflop" uses a column called "cnt_p_3bet" which uses the above field.
Alternatively, click "insert" and sort the database fields alphabetically (most things you'll want are in holdem_hand_player_statistics or holdem_hand_player_detail) - the DB fields are named consistently so you're looking for things starting with flg_p_ for true/false preflop values, for instance.

[Gster]

Thanks a lot guys!

[WhiteRider]

You're welcome.