All in % sng,tourneys

[Bpug]

I would like to build a stat that shows what percentage of hands they push all-in. How to edit this to work with sngs and tourneys: cnt_p_push: sum(if[ holdem_hand_player_statistics.enum_allin = 'P', 1, 0]) ?

[kraada]

That would count how many times they were all-in preflop yes. In your opportunities column you could just use cnt_hands but if walks are common in your games you might want to exclude those (lookup_actions_p.action != '')

[Bpug]

I got an error: [ img ] What should I do?
I am trying follow this tutorial: https://www.pokertracker.com/forums/vie ... 6&p=114853

[WhiteRider]

Firstly, for tournaments you will need to add "tourney_" to the start of the database table name.
To include kraada's additional check you need to add that inside the expression, not after it:

sum(if[ tourney_holdem_hand_player_statistics.enum_allin = 'P' AND lookup_actions_p.action != '', 1, 0])

See the Tutorial: Custom Reports and Statistics for more information on how to construct column expressions.