Finding average players fold to 3bet

[Filterun]

I'm interested in finding out (from my small sample) how much a random player at NL25 folds to a 3bet. However, its occured to me that because I have so many more hands on me than on random players, my fold to 3bet is going to taint how often a random player folds to a 3bet.

e.g
1000 hands on me (0% fold to 3bet)
1000 hands on all other players (100% fold to 3bet)
The amount players at NL25 fold to 3bets: 50%, which is obviously false.

Is there some filter I can use to find the average fold to 3bet, not including MY fold to 3bet?

[kraada]

Create a custom report in the Player Statistics section with the fold to 3-bet statistic. In the blue filters section uncheck "filter on active player" and add the following text filter exactly as written:

player.id_player not in (SELECT p.id_player from player p where p.id_player = (SELECT setting_value from settings where setting_name = 'my_player_id'))

Then run your report.

[Filterun]

Thank you for the help, however when I copy and paste the filter into the "filter expression" box, it says the experssion is not valid. Is there something else I have to do to make the filter work, or is there just a typo in it?


Im in the player statistic section, with "filter on active player" unchecked.

[WhiteRider]

It doesn't validate for me either – I'm sure Kraada will correct it when he comes on later.

[kraada]

Sorry I missed the explicit typecast.

This will work:

player.id_player not in (SELECT p.id_player from player p where p.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))

[Filterun]

Sorry I missed the explicit typecast.

This will work:

player.id_player not in (SELECT p.id_player from player p where p.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))

This filter is solid gold.

If I want to find other stats, will this filter still work?

[WhiteRider]

All that filter does is eliminate your player from the stats - it should work for any stat.