new column "cnt_steal_def_saw_f_bb"

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

new column "cnt_steal_def_saw_f_bb"

Postby cheerful » Mon Jan 16, 2012 9:48 pm

Hello,

i want a new column "cnt_steal_def_saw_f_bb" (Number of times player faced a steal defense opportunity in the big blind and saw the flop.)

but the following expression seems not work:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_f_saw, 1, 0])

what's wrong? many thanks in advance!
cheerful
 
Posts: 9
Joined: Mon Jan 16, 2012 9:28 pm

Re: new column "cnt_steal_def_saw_f_bb"

Postby WhiteRider » Tue Jan 17, 2012 4:28 am

That expression validates for me, and looks like it should work. What problem do you have with it?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new column "cnt_steal_def_saw_f_bb"

Postby cheerful » Tue Jan 17, 2012 5:29 am

many thanks for the reply!

it works now.

firstly i builded a new stat and added it to the HUD: "BB Steal Def Saw F WTSD": ( cnt_steal_def_opp_bb_wtsd / cnt_steal_def_saw_f_bb ) * 100, but it didn't appear on the HUD (cache rebuilded), instead only a blank. but after i ran it in under "reports", it appear on the HUD.
cheerful
 
Posts: 9
Joined: Mon Jan 16, 2012 9:28 pm

Re: new column "cnt_steal_def_saw_f_bb"

Postby kraada » Tue Jan 17, 2012 9:08 am

Thanks for following up - I'm glad to hear you got everything working properly.
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 1 guest