Report: AA vs KK and KK vs AA

[effendi11]

Is it possible to make a report to see if we win/lose money when we get deal AA or KK, and villain also have AA or KK ?
thx

[kraada]

Yes, use the following filter in the blue Filters area to filter to only hands like this:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_hand_player_detail chpd WHERE chps.id_hand = chpd.id_hand and chpd.flg_hero and chps.id_holecard in (1, 26)) AND cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_hand_player_detail chpd WHERE chps.id_hand = chpd.id_hand and not(chpd.flg_hero) and chps.id_holecard in (1, 26))

This will filter to all hands where hero was dealt AA or KK and some other player also showed AA or KK.

[Mistralli]

can this report also be created for tournaments, and is there a guide somewhere on how to make reports?

[kraada]

Yes, it goes on the My Reports tab, and it will work for tournaments, just replace "cash" with "tourney" in the filter definition when it shows up and then it will work for tournaments just fine.

[Mistralli]

ok, after trying for a while, i've completly failed at it. I've never made a costum report and i have no clue on how to start. But i relay want to learn how to do it. if someone is willing to give me some pointers on how it works.

i can't find anywhere something like this: cash_hand_player_statistics.id_hand Do i need to create it? if so where and how do i do that?

Thanks

[kraada]

Go to the My Reports page in PT4. Click the New Report button on the left hand side and choose Hand then click Finish.

Click the blue Filters link on the left hand side and paste in the text given above (just change "cash" to "tourney" as stated), click Save and then OK.

That should be all you need to do.

[Mistralli]

thanks for the help.

I get the following error:

expression not vallid

[kraada]

Oh, that's right, this changed in the most recent beta - my apologies. This will work for you now:

tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps WHERE chps.flg_hero and chps.id_holecard in (1, 26)) AND tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps WHERE not(chps.flg_hero) and chps.id_holecard in (1, 26))

[Mistralli]

thank you it worked

[dryath]

Hey Krada, trying to get this same report for cash games. - (so i know how many AA v KK or KK v AA) im getting each session/overall etc.

Tried to click the blue filters and copied in what you had as a new expression filter (didnt work) - but im guessing its different now like you said from an update. Love it if you could lend a hand!


Thanks, and btw you do a fantastic job with the support on this forum, A+ man thanks again