Hand report against fishes

[Aerith]

How can I create a hand report showing the hands I've played against fishes with a VPIP greater than 40? Thank you

[Flag_Hippo]

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) > .40)

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. If the filter returns an error then change the hands dropdown to 'Max 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. Should you want to be more specific with the query such as specifying a sample size or specific actions for the player you can add to the expression. If you need it see this guide for the basics on custom filter/statistics creation, this guide for a deeper walkthrough and for more on how SELECT works see here.