WhiteRider wrote:Both of those expressions validate for me - you are entering them in Expression field on the Columns tab, in the Holdem Cash Player Statistics section, right?
cnt_3BbuttonvsCO_AA:
sum(if[lookup_actions_p.action LIKE 'R%' AND holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.id_holecard = 1,1,0])
..looks OK, but actually checks for times the button made the last aggressive action preflop.
If you want to check for 3-bets explicitly you'll need to check for "holdem_hand_player_statistics.flg_p_3bet" (instead of the "actions" check).
Similarly for your "chances" column, it only says the button faced a raise, not that they faced a 2-bet (first raise) explicitly. To do that you could use:
holdem_hand_player_statistics.flg_p_3bet_opp
Yeah, I did put 'cnt_3BbuttonvsCO_AA' into the expression field... oops. The stat ended up being incorrect (it was always 0/0). I'm going to try it with your suggestions now.
Also, it takes FOREVER to update my cache after making this stat. Yesterday, it took 2 hours for the one stat and it looks like it will take forever right now. Is there any workaround for that? Can I create a stat while auto importing (since it is constantly updating the cache)?