Page 1 of 1

Open shove by position

PostPosted: Fri Jan 21, 2022 10:57 am
by jorre vennincx
Hi,

I am trying to create open shove stats by position(BTN this one) and this is what i have but its an invalid expression. I feel like i should be close to the correct answer. can anyone help me ?

sum(if[tourney_hand_player_statistics.position = 0 AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

Re: Open shove by position

PostPosted: Fri Jan 21, 2022 2:31 pm
by Flag_Hippo
It is valid when used for a new column:

Capture.PNG

If you are getting an 'Invalid Value Expression' error then that means you are entering the expression directly in the 'Value Expression' field on the 'Stats' tab and that isn't how custom statistics are created - see this guide for the basics on custom statistics creation. You will also need a second custom column that counts the opportunities as well but there is a statistic called 'Open Shove' already available in the Download Warehouse. You can then use that statistic to generate results for all positions in a report grouped by position or for a HUD stat using the 'Position' property in the HUD Profile Editor or by creating your own positional popup.

highfalutin