stats flop seen

[lifeisagame69]

i copy coll this one
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t.action LIKE "X_%", 1, 0])still saying invalid sql blablabla

[kraada]

Try this instead:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = 'XC' and lookup_actions_t.action LIKE 'X_%', 1, 0])

[lifeisagame69]

ok so this one is for the when defend bb c/f flop %?

Anyway i can save it for a new column.






but for this one
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t.action = "XF", 1, 0])

who is supposed to be when defend in bb c/c /cf turn ?

they said again the statement isn t valid

[kraada]

The one with X_ is how often they check and face a bet.
The one with XF is how often they check and fold to a bet.

You create the percentage of how often they check/fold the flop by putting the XF column over the X_ column.

Also, if you replace the " with ' it will validate.

[WhiteRider]

You need single quotes round the strings, not double.
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = 'XC' and lookup_actions_t.action = 'XF', 1, 0])

[lifeisagame69]

so

i add this one in new column
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = 'XC' and lookup_actions_t.action = 'XF', 1, 0])

?
this one is for c/c c/f when denfend bb by a call?

and after i go ot statistic and insert the name of the column i just create?

[WhiteRider]

That column counts the number of times the player:

sum(if[
holdem_hand_player_statistics.flg_blind_def_opp faces a steal from a blind position
and not(holdem_hand_player_statistics.cnt_p_raise > 0) doesn't raise preflop
and lookup_actions_f.action = 'XC' exactly check/calls the flop
and lookup_actions_t.action = 'XF' exactly check/folds the turn
, 1, 0])

Depending on exactly what you want to show you will probably need another similar column to count the number of times the player had an opportunity to make those actions. Exactly how you define that will depend on how you define an opportunity? I guess that would be exactly the same but that they check and then face action on the turn?
In which case your opportunities column would be this:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = 'XC' and lookup_actions_t.action LIKE 'X_%', 1, 0])

See this tutorial for a walkthrough of how to build a stat from a pair of columns like this.

You may find the rest of the Tutorial - Custom Reports and Statistics useful too, especially this section if you want to make other similar stats.