sam_hawkins wrote:I am trying to build an MTT statistic that will be calculated for every hand (so I suppose it would be a T(ourney)/hand statistic) so that I can plot it on a graph as an overlay stat.
sam_hawkins wrote:The information I cannot find is the 'starting_stack' amt. I found the code for how to get the number for summaries (for example here) but not as a hand statistic. Can somebody help me how to write a starting stack stat that can be accessed in the above calculation?
(partition by tourney_hand_player_statistics.id_tourney order by tourney_hand_player_statistics.date_played)
WhiteRider wrote:I'm don't think that that will work as a Player stat. Your expression wants to have a single value, but across all hands for a player there would be multiple values so the result would be undefined.
For example in a Player stat "amt_won" is the total amount of chips won or lost across all of the hands, but your "amt_starting_stack" is [trying to be] the starting stack in a single hand, and that won't work.
You may be able to get it to work by doing the whole calculation in a column, but you're mixing different levels of data (hand data and overall tournament data) and I think that still won't work.
Users browsing this forum: No registered users and 1 guest