Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
by 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
by 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
by 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
by 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
by 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
Users browsing this forum: No registered users and 19 guests