Hand report against fishes

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Hand report against fishes

Postby Aerith » Sun Apr 16, 2023 11:58 am

How can I create a hand report showing the hands I've played against fishes with a VPIP greater than 40? Thank you
Posts: 1
Joined: Sun Jan 29, 2023 12:11 pm

Re: Hand report against fishes

Postby Flag_Hippo » Mon Apr 17, 2023 11:02 am

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.
Posts: 14637
Joined: Tue Jan 31, 2012 7:50 am

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 16 guests