The stat have to calculate only pfr versus bb excluding allin preflop and btn action.
I tried in this way, but I think is not good
(cnt_pfr_SB_13 / cnt_hands_SB_13) * 100
cnt_pfr_SB_13:
- Code: Select all
sum(if[tourney_hand_player_statistics.cnt_p_raise > 0 AND NOT (tourney_hand_player_statistics.flg_p_limp) AND lookup_positions.flg_sb AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 13, 1, 0])
cnt_hands_SB_13:
- Code: Select all
sum(if[tourney_hand_player_statistics.id_hand > 0 AND lookup_positions.flg_sb AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 13, 1, 0])