That would require a custom expression filter using a subquery like this:
- Code: Select all
cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player group by chps.id_hand, chps.id_player having ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) < .35 and (sum(cc.cnt_hands) > 1000 and not chps.flg_hero))
You can use this expression filter by clicking on the 'Filters' link in a custom report
and selecting 'Add New Expression Filters' and you will need to replace all instances of 'cash' with 'tourney' if you are in a tournament report.
This particular expression will filter for players with less than 35% VPIP and more than 1,000 hands but bear in mind that if you are not playing heads up games then this will only be filtering to hands where players like this were dealt in at the table - not that they played in a pot against you but you can edit this code to be more specific with regards to the actions they take and/or add/use different columns for testing other values. Also if you use a custom hand report and the filter returns an error then change the hands dropdown to 'All Hands' but bear in mind that filters like this can generate a lot of PostgreSQL processing so can take a while to complete if you have a large database.
If you need it see this guide
for the basics on custom statistics creation, this guide
for a deeper walkthrough and for more on how SELECT works see here