Page 1 of 1

Filter Villains hand at showdown

PostPosted: Mon Jan 18, 2021 7:08 pm
by paulwol56
Hi there, decided to have a go at range / hand reading, problem I only have @ 400 hands that hero went to showdown with, and alot of these hands villain only has a very low number, is it possible to filter to a minimum of say 30 plus hands for villain at showdown, this will give me a chance to get started. cheers Paul

Re: Filter Villains hand at showdown

PostPosted: Tue Jan 19, 2021 7:53 am
by Flag_Hippo
Can you please clarify this for me as I'm not sure exactly what it is you are trying to do here.

Re: Filter Villains hand at showdown

PostPosted: Tue Jan 19, 2021 5:38 pm
by paulwol56
Hi Hippo when it comes to to studying the showdowns through pt4 replayer I have @ 400 hands, but out of those 400 hands I will be lucky to have 80 hands from the villians that I can study due to the rest only having a handfull against me So instead of having 400 hands in the replayer of which 80% are no good due to low numbers from villains I would be able to fill the replayer up with the 80 that I can study. if there is a filter that i could say villian must have played at least 30 hands against me then I would not need to load my replayer up with all villian hands against me, and this will make studying much more enjoyable rather than playing the replayer having to go through many hands with villain having played only a few hands agaisnt me,then this would be good th know going forward, Thanks again for your help cheers paul.

Re: Filter Villains hand at showdown

PostPosted: Wed Jan 20, 2021 7:52 am
by Flag_Hippo
Create a custom 'Hand Report' in 'My Reports' and then use this custom filter:

Code: Select all
cash_hand_player_statistics.flg_showdown and 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))) >= 30)) and chps.flg_showdown and NOT chps.flg_hero)

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters' and you will need to replace "cash" with "tourney" if you are in a tournament report.

Re: Filter Villains hand at showdown

PostPosted: Wed Jan 20, 2021 1:39 pm
by paulwol56
Thank You