Report question

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

Report question

Postby concussed » Sun Sep 12, 2010 10:32 am

I have ticked the box for some Buddys, and also given them an icon label (in these cases "Good Player")
How can i run a report to identify these players and look closer at their hands played ?
i.e Can i Filter them somehow to just show these particular players ?
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Report question

Postby kraada » Sun Sep 12, 2010 10:48 am

Please see this thread for details on how to create the filter you're looking for.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report question

Postby concussed » Sun Sep 12, 2010 11:29 am

Hi, well i'm struggling to follow the linked thread, so decicded to plough on and anyway, I've got a report showing the following:

Player
Hands
VPIP
PFR
CallPFR
CPP

and this shows everyone, so I want to filter hands to say only show people with more than 50 hands, How can I do this please ?
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Report question

Postby kraada » Sun Sep 12, 2010 11:55 am

Click on the blue Filters link, and click Insert. Find Hands on the Statistics tab, click Ok, then add >= 50 (so the entire line will look like #Hands# >= 50) then click Save. Save and run your report and it'll be so filtered.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report question

Postby concussed » Sun Sep 12, 2010 11:58 am

got it, thank you.

i found this you had posted on another thread...

"For example, to filter a Holdem Cash Player Statistics report to only show players who have played more than 100 hands you could enter this expression:
#Hands# > 100
Statistic names are identified using # either side. To enter this same filter using the Column instead of the Statistic you would enter:
cnt_hands > 100"

which did it for me. cheers.
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Report question

Postby kraada » Sun Sep 12, 2010 12:56 pm

That works too, but if you want to make sure you don't have to worry about typos you can use the insert link I described :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report question

Postby concussed » Sun Sep 12, 2010 3:54 pm

I'm on a roll.....

Is it possible to have my stats on the report regardless of the filters so I can compare and contrast ?!
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Report question

Postby WhiteRider » Sun Sep 12, 2010 4:24 pm

No - the filters apply to the whole report, but you could run it for yourself without filters and expand that report (click the 4-arrow icon to the right) and then re-run it with the filters enabled.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests