I am trying to write a custom stat from the perspective of the BB so I don't think that approach using 100-(vpip from SB) will work.
Since I am interested in this stat mainly for HU Hypers on Stars I defined a column min_stack_BB_HU_Hypers_Pokerstars to count the effective stack size which should work even when facing an open fold (starting stacks are 500 chips on these games):
- Code: Select all
if[tourney_hand_player_statistics.amt_before <= 500, tourney_hand_player_statistics.amt_before, 1000 - tourney_hand_player_statistics.amt_before] / tourney_blinds.amt_bb
What Summary Type should I choose: Count, Count Unique, Min? Is there any documentation for these fields?
Then I defined the Faced Open Fold 16-30bb as:
- Code: Select all
sum(if[tourney_hand_player_statistics.cnt_p_face_limpers = 0 and tourney_hand_player_statistics.amt_p_raise_facing = 0 and lookup_positions.flg_bb and min_stack_BB_HU_Hypers_Pokerstars between 16 and 30, 1, 0])
However when I run reports it will show one row for each hand. I tried changing the Summary Type for min_stack_BB_HU_Hypers_Pokerstars but it has no effect. How can make the reports show just one row for this stat?
Thanks.