Stats sens

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

Stats sens

Postby raph156 » Wed Aug 31, 2011 8:00 pm

Hi,
I want % time player fold when facing a bet between 10bb and 25bb
i created thise column:
sum(if[holdem_hand_player_detail.amt_f_bet_facing > ( 10 * holdem_limit.amt_bb) and holdem_hand_player_detail.amt_f_bet_facing <= ( 25 * holdem_limit.amt_bb), 1, 0])
sum(if[holdem_hand_player_detail.amt_f_bet_facing > ( 10 * holdem_limit.amt_bb) and holdem_hand_player_detail.amt_f_bet_facing <= ( 25 * holdem_limit.amt_bb) AND (lookup_actions_f.action SIMILAR TO '(F|XF)%'), 1, 0])
the stat:
((bff10_25f ) * 100) / (bf10_25f )
the resulte seems to be wrong
Tx for help.
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby raph156 » Thu Sep 01, 2011 4:04 am

i try thise too, not better...
sum(if[holdem_hand_player_detail.amt_f_bet_facing > ( 10 * holdem_limit.amt_bb) and holdem_hand_player_detail.amt_f_bet_facing <= ( 25 * holdem_limit.amt_bb) AND holdem_hand_player_statistics.flg_f_fold, 1, 0])
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby WhiteRider » Thu Sep 01, 2011 4:06 am

Those expressions look OK - what sort of results are you getting?
If you want us to check out your stat please export it and attach it to a Support ticket and include a link to this thread.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats sens

Postby raph156 » Thu Sep 01, 2011 6:52 am

All right, its work
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests