Gropu ranges by hole cards: Amount won

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Gropu ranges by hole cards: Amount won

Postby GbjAndyS » Sun Sep 28, 2008 2:21 pm

Anyone can tell me how create a single report like this (amounts are only for sample) ?

Range Groups Amount Won

1 AA, KK $205.64
2 TT, JJ -$35.56
3 AK, QQ $96.80
4 67s+, 68s+ -$5.39
5 AQ, AJ, AT $18.15
6 KQ, KJ, QJ, KT, QT, JT, J9, J8 -$20.20
7 Axs, Kxs, Qxs -$8.88
8 66-99 $7.25
9 22-55 $2.30
10 67o, 86o -$15.59

I have found only the way to do it with 10 separate reports, using the "id_holecard" filter for each range.

Sorry for the bad column formatting, i hope can be read anyway !
GbjAndyS
 
Posts: 6
Joined: Thu Jul 10, 2008 10:38 am

Re: Gropu ranges by hole cards: Amount won

Postby WhiteRider » Sun Sep 28, 2008 5:17 pm

I don't think this can be done in a single report.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Gropu ranges by hole cards: Amount won

Postby dendron » Fri Oct 03, 2008 11:04 am

Maybe you can make a custom stat for each hand range and the results come out in columns rather than rows? Hopefully something gets worked out so we can create reports as posted in the OP though. I always do post session analysis and it takes forever to run through all the filters I want to look at.
dendron
 
Posts: 31
Joined: Fri Jan 25, 2008 10:33 pm

Re: Gropu ranges by hole cards: Amount won

Postby WhiteRider » Fri Oct 03, 2008 2:24 pm

Yes, that should work.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Gropu ranges by hole cards: Amount won

Postby GbjAndyS » Mon Oct 06, 2008 1:49 pm

dendron wrote:Maybe you can make a custom stat for each hand range and the results come out in columns rather than rows? Hopefully something gets worked out so we can create reports as posted in the OP though. I always do post session analysis and it takes forever to run through all the filters I want to look at.


Can you post an example please ? I don't have understand how to make this custom stat, thank you !
GbjAndyS
 
Posts: 6
Joined: Thu Jul 10, 2008 10:38 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 4 guests

cron