statistic "faced all in preflop"

[nyjedsazi]

how to create?

for tourneys.

ty.

[WhiteRider]

What exactly do you want to count? Just the number of times a player face an all-in preflop, or that as a percentage of all hands?
I'm not sure what that would tell you..?
If you want to see hands where you faced an all-in you can do that in the Filter window.

[nyjedsazi]

it's not very easy for me to explain what I want :)

actually I need to add a condition to one of my stats like "AND NOT (facing all in preflop)"

so this stat will help me

Just the number of times a player face an all-in preflop

[kraada]

Then add:

AND NOT(tourney_holdem_hand_player_statistics.enum_face_allin = 'P')

to your stat. P is preflop, F is flop, T is turn and R is river.

[nyjedsazi]

tyvm! :)

[nyjedsazi]

hm. it doesn't work/ says that the statement is not valid SQL

tourney_holdem_hand_player_statistics.enum_allin = 'P' - this works

tourney_holdem_hand_player_statistics.enum_FACED_allin = 'P' - this doesn't

but I need second expression for my stat

my column now :
cnt_bb_steal_call_noAI
sum(if[tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'C' AND NOT (tourney_holdem_hand_player_statistics.enum_allin = 'P'), 1, 0])

and I want to add a condition for not to count a call when we are facing all-in

[WhiteRider]

The database field is "face", not "faced":

tourney_holdem_hand_player_statistics.enum_face_allin