FILTER HERO VS PLAYERS VPIP>40%

[HYPERION666]

How can I filter hands of hero vs players with VPIP> 40%

[Flag_Hippo]

If you want hands where a player with VPIP > 40 was dealt in you can use this:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps where chps.id_player in (SELECT cc.id_player from cash_cache cc where true group by cc.id_player HAVING ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .4))

For more on how SELECT works see here. You can use this expression filter by clicking on the 'Filters' link in a custom report and selecting 'Add New Expression Filters'. Also there is a known issue with this type of filter returning an error in hand reports so to workaround that you'll need to change the report to display 'All Hands' instead of 'Last x Hands'.

[HYPERION666]

I followed the steps and nothing appears the report remains loading for several hours.

picture hosting

[HYPERION666]

I followed the steps and nothing appears the report remains loading for several hours.

picture hosting

I'M SORRY I DON´T KNOW UPLOAD IMAGES TO THE FORUM

[Flag_Hippo]

Complex custom filters like this take alot of processing and can take awhile to complete especially if you have a large database. You can test the filter in a smaller database to make sure that it works but if you need further assistance on your main database please report this to us in a Support Ticket with your log file:

Guide: How to Create & Submit a PokerTracker4.log File