filter three of a kind on flop for opponent

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

filter three of a kind on flop for opponent

Postby socorrista5 » Wed Jan 30, 2013 3:33 pm

Hello,
How can I create a filter to show the hands when my opponent has a pocket pair and has three of a kind in the flop?

Thanks
socorrista5
 
Posts: 142
Joined: Mon May 24, 2010 7:56 am

Re: filter three of a kind on flop for opponent

Postby kraada » Wed Jan 30, 2013 5:33 pm

The easiest thing to do is to create a Hand report and uncheck Filter on Active Player in the blue Filters link -> Filter Expressions area. Then in the Filters -> Simple Filters area create a filter for a set with Hand Values -> Made Hand -> Three of a Kind and then you can see only hands where someone made three of a kind of the flop. You can add not(Player is Hero) to eliminate times where the set was made by you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter three of a kind on flop for opponent

Postby socorrista5 » Wed Jan 30, 2013 5:53 pm

That's a good approach, but If I do that (uncheck active player) I am not sure If I can also filter things like myself (Hero) seen the flop, something like this:

An opponent has pocket pairs, in the flop the opponent has a three of a kind, and Hero also sees the flop.

Do you thing that would be possible?

Thanks
socorrista5
 
Posts: 142
Joined: Mon May 24, 2010 7:56 am

Re: filter three of a kind on flop for opponent

Postby kraada » Wed Jan 30, 2013 6:36 pm

You can do this it's just a little trickier and the report will end up taking longer to run. If you add this in the Filter Expressions area it will require Hero to have seen the flop:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps where chps.flg_hero and chps.flg_f_saw)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter three of a kind on flop for opponent

Postby socorrista5 » Thu Jan 31, 2013 4:03 pm

Thanks a lot, it works!!!. It takes a while, but not too much.

But I have a question, by doing it I (filter + expression) I expected to have under "My C Won" the money I won/lost in the corresponding hand, but the "My C Won" I see not my money but the opponent money, also his Hole Cards.
Is it correct???? There is not a way of see my currency won/lost under that reports?

Thanks a lot
socorrista5
 
Posts: 142
Joined: Mon May 24, 2010 7:56 am

Re: filter three of a kind on flop for opponent

Postby kraada » Thu Jan 31, 2013 4:27 pm

You're looking at things currently from his perspective. Doing it from your perspective for this particular kind of report is a bit more complicated and the custom filter expression you'd need to use would slow things down at least twice as much.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter three of a kind on flop for opponent

Postby socorrista5 » Thu Jan 31, 2013 5:15 pm

Ok, then I'll try to make it with this report and see what I can find.

Thanks
socorrista5
 
Posts: 142
Joined: Mon May 24, 2010 7:56 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 19 guests

cron