Attempt to Steal from SB

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

Attempt to Steal from SB

Postby Blinky » Sat Apr 10, 2010 12:09 pm

Trying to figure out what I need to do to add this.

Attempt to steal is
Code: Select all
(cnt_steal_att / cnt_steal_opp) * 100


I see a "position" column I can add, but that says position from the BTN. Unless I can use position -1 (1 left of btn), what do I do?

Any chance someone could post the full code I can just copy/paste in or add to a duplicated "Att to steal" stat?
Blinky
 
Posts: 4
Joined: Thu May 15, 2008 12:04 am

Re: Attempt to Steal from SB

Postby VladimirN » Sat Apr 10, 2010 12:37 pm

Theres already a made stat called "Att To Steal:SB"
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Attempt to Steal from SB

Postby kraada » Sat Apr 10, 2010 12:42 pm

For the record, SB is always position 9; all positions in PT3 are positive numbers. Att to Steal:SB is available in Beta 30.9 though, I don't believe it was in Build 5.2, so if you haven't got it, upgrading should get it for you.
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