Thank you. It depends on exactly what you want to count but for this type of statistic most people would just the default cbet column for the opportunities:
cnt_fcbet_49pot- Code: Select all
sum(if[tourney_hand_player_statistics.flg_f_cbet and tourney_hand_player_statistics.val_f_bet_made_pct between 36 and 49, 1, 0])
cnt_f_cbet- Code: Select all
sum(if[tourney_hand_player_statistics.flg_f_cbet, 1, 0])
(cnt_fcbet_49pot / cnt_f_cbet) * 100This will tell you out of all their cbets what percentage were the size specified.
If instead you did:
cnt_fcbet_49pot- Code: Select all
sum(if[tourney_hand_player_statistics.flg_f_cbet and tourney_hand_player_statistics.val_f_bet_made_pct between 36 and 49, 1, 0])
cnt_f_cbet_opp_49pot- Code: Select all
sum(if[tourney_hand_player_statistics.flg_f_cbet and tourney_hand_player_statistics.val_f_bet_made_pct between < 49, 1, 0])
(cnt_fcbet_49pot / cnt_fcbet_opp_49pot) * 100then this would tell you what percentage of cbets under 49% sizing were the size specifed in the first column. Bear in mind that between is the same as using >= and <= so by using < in the opportunities column you might get hands not counted there that were counted in the action column. In other words:
tourney_hand_player_statistics.val_f_bet_made_pct between 36 and 49 (this will include bets that were exactly 49%).
tourney_hand_player_statistics.val_f_bet_made_pct <= 49 (this will include bets that were exactly 49%).
tourney_hand_player_statistics.val_f_bet_made_pct between < 49 (this will NOT include bets that were exactly 49%).