PokerTracker

I want to make a report to see how many times I have KK vs AA, and vice versa. I cant figure out how to create a statistic or filter for my opponents hole cards however. Any help would be greatly appreciated.

Add these as separate custom filters to a hands report:

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 1)

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 26)

Then you'll only see hands where one player had AA (id_holecard = 1) and another player had KK (id_holecard = 26) and it got to showdown (so that we saw the cards). If you filter to active player you'll see only hands you were involved in one way or the other.

If you want to limit to hands you had one or the other add a separate filter for:
holdem_hand_player_statistics.id_holecard = X where X is either 1 or 26 and whichever you want to see - if you're filtered on active player, it will limit it appropriately.

thanks that worked.

Follow-up directions:

On the Holdem > Cash Games > Reports tab create a report in the Holdem Cash Hands section. (For other game types the directions are the same, but choose the relevant game. The filters will need to be changed appropriately too.)
Give your new report a name.
Add the stats you're interested in to your report. I'd suggest at least: Player, Hand #, Hole1, Hole 2.
Click the blue Filters link in the reports section on the left.
Make sure that Filter on Active Player is ticked.
Paste the first of the above filters into the Filter Expression field and click Save. You should see the filter appear in the top section.
Click New, and then paste the second filter expression into the (now blank) Filter Expression field and click Save again.
Click OK to close the report filters window.
You can now run your report.

I have attached the report (zipped, you need to extract it first) for you to import, and I'll add it to the "Get More" section too.

Thank you for your help

I downloaded the filter and have a question.

- I unchecked "filter for active player"

What doest the Player column mean then?

http://img844.imageshack.us/img844/9660 ... 007392.jpg

http://img835.imageshack.us/img835/8059 ... 007425.jpg

f.e. why is "dr leroc" in this column here?

That is showing every player for each hand where someone has AA and someone else has KK.
If you don't want to see the other players you'll need another filter, either for going to showdown or having known hole cards (e.g. holdem_hand_player_statistics.id_holecard > 0).

I just asked why "dr leroc" (f.e.) is in the "player" column. He didnt have AA or KK.

ah sry, I took a look at the handno now and saw that they are 9 times the same number for a 9max table f.e.

everything fine, tu