bump! any news on this?
To count the number of hands in the bb including walks, when the smallest stack is between 0 and 8 I tried to use live_table_min_stack but for some reason it is not working.
- Code: Select all
sum(if[tourney_hand_player_statistics.id_hand > 0 and lookup_positions.flg_bb AND (live_tourney_table.amt_min_stack / live_tourney_table.amt_bb) BETWEEN 0 and 8, 1, 0])
Even if it worked it would be useless in reports though there are other ways to get the same information.
I think there should be a way to count walks in the BB at a given stack size interval even if the current definition of effective stack won't allow it. This could be solved by explicitly storing the smallest stack for each hand or alternatively storing the starting stacks for the tournament type, from which the smallest stack can be deduced using amt_before. Note that I am interested in HU tables only.