Versus # of opponents

[gman]

Hi, I have a question about stats that take the number of opponents a player was facing at the time they made a decision. Is it possible to find [ % of the time a Player won in showdown when they saw the flop against 2 opponents] or {[ % of the time a Player won in showdown when they 3-betting the flop against 2 opponents]. Thanks in advance, i looked in the manual. Just an example would be awesome.

[gman]

bump

[kraada]

You would need to create a couple of custom stats but they shouldn't be that bad.

There's a database field: holdem_hand_summary.cnt_players_f which is the count of how many players saw the flop.

So for went to showdown when seeing the flop vs 2 players it would be, in the Holdem Cash Player Statistics section, create first a new column, call it cnt_3_handed_flops, defined as:
sum(if[holdem_hand_summary.cnt_players_f = 3 and flg_f_saw, 1, 0])

Then another column cnt_3_handed_flops_wtsd:

sum(if[holdem_hand_summary.cnt_players_f = 3 and flg_f_saw and flg_showdown, 1, 0])

Then create a stat on the stats tab that puts one over the other, times 100 to make it a percent and you should be all set. Don't forget to add information on the stat's format tab so you can see it in reports.

[gman]

Thank you for your assistance, but both of those statements say NOT VALID SQL,

[kraada]

Oops, that should be holdem_hand_player_statistics.flg_f_saw and holdem_hand_player_statistics.flg_showdown - I think those table names are likely required for those fields.