3Bet average size

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

3Bet average size

Postby majonyjony » Mon Jan 10, 2011 2:29 pm

I create this column

sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct
, 0])
But not correct,
Is posible to create this?
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: 3Bet average size

Postby kraada » Mon Jan 10, 2011 2:40 pm

I just tested and "sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct, 0])" validated for me after I removed your extra return. Or do you mean the numbers are not working properly?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 3Bet average size

Postby majonyjony » Mon Jan 10, 2011 2:53 pm

The problem is when I create a stat
(3BET_suma* / cnt_p_3bet )
*sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct, 0])

No funciona in general tab-player statistics.
"Unable to execute query....."(too long)
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: 3Bet average size

Postby kraada » Mon Jan 10, 2011 2:56 pm

I believe column names need to start with alphabetic characters (ie- not numbers) in order to function properly. If you change your column name does it work then?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 3Bet average size

Postby majonyjony » Mon Jan 10, 2011 3:43 pm

Yes, its OK.
TY Kraada!
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am


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

Who is online

Users browsing this forum: No registered users and 0 guests