I'm trying to build some stats, at the moment I'm stuck with cBet vs. Raise stats on the Flop.
I want to know how often villain calls/raises/folds to them...
I created a colum "cnt_f_cbet_vs_raise_call" to figure out how often he calls, but I get an error when I use
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise AND lookup_actions_f.action == "BC", 1, 0])
My second colum counts the how often villain faces a raise after his FCbet "cnt_f_cbet_vs_raise":
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise, 1, 0])
Would be great to get some help here...