FILTER HANDS REG/FISH

[injectio]

Hello, I'd like to analyze the hands of players I've played fewer than 150 hands against. I'm having trouble separating the regular players from the weak ones in the hand report tab. Can you help me? Thank you. :D

[Flag_Hippo]

If you are not using a custom hand report then go to 'My Reports' and create a 'Hand Report':

Guide: Creating My Reports

And then add one of the following two expression filters depending on whether this is for cash games or tournaments:

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_hands))) < 150)))

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having ((((sum(tc.cnt_hands))) < 150)))

This expression filter will return hands where there is a player at the table with less than 150 hands. You can use the expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. If you receive a query error when using the expression change the hands dropdown in the report from 'Most Recent 100 Hands' to 'Max Hands'.

[injectio]

Hello, thank you for your reply. Unfortunately, the expression is not valid. I did enter "maximum number of hands". I'm playing spins and I did select "tournament". I'm generating a non-personalized hand report. I don't understand. Could you help me? Thank you. ;)

[Flag_Hippo]

Unfortunately, the expression is not valid.

The expression is valid:

exp.PNG

(27.48 KiB) Downloaded 748 times

[injectio]

I can't do it. I don't understand where the error is coming from. :( :|

[Flag_Hippo]

The attached custom report has this filter saved:

150.zip

(2.8 KiB) Downloaded 99 times

If you extract the file and import this custom report does that work for you?