Call steal

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

Call steal

Postby Bole » Tue Dec 20, 2011 4:42 pm

Hello,

Could someone help me with the design of Call steal custom stat.

There are BB call steal and SB call steal stats. I want them merged into 1 stat, call steal (from blinds obv, button excluded).

What is value expression and do i have to add anything else in format, categories or colors ?

Thank you.
Bole
 
Posts: 9
Joined: Tue Apr 12, 2011 10:55 am

Re: Call steal

Postby kraada » Tue Dec 20, 2011 5:20 pm

The value expression you want then is:

((cnt_bb_steal_call + cnt_sb_steal_call) / (cnt_steal_def_opp_sb + cnt_steal_def_opp_bb) * 100

/%.2f is probably what you want in the Format Expression and you do need to enter some title and width for your stat but you can enter whatever you choose in that area.

For this stat, no custom columns are required.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Call steal

Postby Bole » Tue Dec 20, 2011 5:32 pm

Thank you kraada, it works.
Bole
 
Posts: 9
Joined: Tue Apr 12, 2011 10:55 am


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

Who is online

Users browsing this forum: No registered users and 2 guests