Filter 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

Filter question

Postby lifeisagame69 » Tue Jan 03, 2012 2:13 am

Hi,

I would like to check some statistic about my database.

So, i'm using one filter,
On the general table, on the players area, i set up hands between 2 and 2 players at the tables.

But i want to filter hands when the SB is the button, the heads up situation.

I guess it's on the position area i should put a number for the button position but i don't know wich one and what the meaning of the different number..
lifeisagame69
 
Posts: 227
Joined: Wed Oct 29, 2008 12:27 am

Re: Filter question

Postby lifeisagame69 » Tue Jan 03, 2012 2:36 am

Also, on the general tab, i can put the standard deviation at player sumary, but i don't find the stadard deviation BB/100 im the player statistics section.
How can i see it?

thanks
lifeisagame69
 
Posts: 227
Joined: Wed Oct 29, 2008 12:27 am

Re: Filter question

Postby WhiteRider » Tue Jan 03, 2012 5:35 am

To filter for small blind you can either use position 9 (the SB is always position 9 and the BB always position 8, regardless of the number of active players), or you can filter for posting the small blind on the Actions tab.

Standard deviation is only defined for sessions in PT3 so you can only add it to reports showing overall session reports.
(See "Sections" in the Tutorial: Custom Reports and Statistics for more information on the different types of reports.)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filter question

Postby lifeisagame69 » Wed Jan 04, 2012 12:54 am

Hi, for the sb position, i want to filter when i'm in sb in Head up match and also that i have the position (i'm last to act)Should i still put the number 9?

Also, for HU, i want to enter the stats 3bet% when button open raise and sb fold (in 3handed situation or if everybody fold before button).

How can i configure that?

thanks
lifeisagame69
 
Posts: 227
Joined: Wed Oct 29, 2008 12:27 am

Re: Filter question

Postby WhiteRider » Wed Jan 04, 2012 4:39 am

Yes, the SB is always position 9 and the BB always position 8, regardless of the number of active players.

lifeisagame69 wrote:Also, for HU, i want to enter the stats 3bet% when button open raise and sb fold (in 3handed situation or if everybody fold before button).

I'm not sure what you mean by this - can you please explain what you want to see, and where?
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 1 guest