Filter results based on the results of previous filter

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

Filter results based on the results of previous filter

Postby jchysk » Fri Jan 08, 2010 12:23 am

Let's say I have a report that looks at all the players I have 5000+ hands with. What's the easiest way I could make another report using only the players from that report? Like looking at all hands of AA or looking at specific stats from the button but wanting to filter all except the players from the first report?
I tried searching for this in the forums since I'm sure it's a common question, but I wasn't sure what terms to search for and couldn't find anything in my first few queries.
jchysk
 
Posts: 29
Joined: Mon Feb 18, 2008 7:40 pm

Re: Filter results based on the results of previous filter

Postby WhiteRider » Fri Jan 08, 2010 5:21 am

You can add more filters to the report to narrow things down.
You can't use that filter to filter the built-in reports, though.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filter results based on the results of previous filter

Postby jchysk » Fri Jan 08, 2010 6:20 am

Alright, what I'm trying to achieve is something like:
find all players where overall PFR > 18% AND PFR at pos 5 < 14%
jchysk
 
Posts: 29
Joined: Mon Feb 18, 2008 7:40 pm

Re: Filter results based on the results of previous filter

Postby kraada » Fri Jan 08, 2010 9:47 am

You'd need to build a custom stat for "PFR at position 5".

To get PFR > 18% you'd add the following filter on the blue Filters link on the custom reports tab:

#PFR# > 18

(Once you have "PFR at position 5" as a stat you can add a second filter in similar fashion for that one.)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests