Help filter report all players.

[zyzzy69]

Hi friends.

I have a report with all players which shows me all the hands that I saved that day from all the players.

What I would like is how to add custom filters to that report, such as:

-Only show accumulated data of rivals with VPIP> 30
-Only show accumulated data of opponents with> 100 hands.

Is there any possibility to add these filters?
Could they be used together?

Greetings and thank you very much

P.D: I leave the image in the following link, I am not able to put it so that it can be seen directly xD

https://i.postimg.cc/nhS0NvLd/stats.jpg

[Flag_Hippo]

That will depend on whether you want to filter that data based on lifetime statistics or only the statistics accmulated on that day. If you want to filter based on the players lifetime statistics then to filter on a statistic such as VPIP is going to require an expression filter with a subquery like this:

Code: Select all

player.id_player in (SELECT p.id_player from player p, cash_cache cc where p.id_player = cc.id_player group by p.id_player HAVING (( sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) > .3)))

That example is for a VPIP above 30 percent but the same principle can be applied to filter for other statistics. For more on how SELECT works see here. For a tournament report just substitute 'cash' with 'tourney'. 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 and/or your database is not on an SSD. Furthermore if built-in filters are also being used then you might not get any results at all. If you want to filter based each players statistics accumulated on that day only then I don't have a filter for that.