New stat

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 stat

Postby raph156 » Thu Mar 08, 2012 5:36 am

Hi,
Holdem tournament player statistics
column:
summary type: sum
a1 : sum( if[ (tourney_holdem_hand_player_statistics.id_holecard = 169), 51.28, 0])
a2 : sum( if[ (tourney_holdem_hand_player_statistics.id_holecard =168), 36.24, 0])
stat:
g1: ( a1 + a2 ) / cnt_hands
result: enable to execute query

Thanks for help.
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: New stat

Postby kraada » Thu Mar 08, 2012 9:55 am

If you change the values to 51 and 36 do they work properly?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New stat

Postby raph156 » Thu Mar 08, 2012 10:57 am

No, they don't.
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: New stat

Postby kraada » Thu Mar 08, 2012 11:38 am

Well that's definitely odd. Could you export, zip up and attach the stat to a support ticket for us? Then we'll be able to investigate more effectively for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New stat

Postby raph156 » Thu Mar 08, 2012 12:44 pm

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 24 guests