Custom Statistics don't show up in HUD

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

Custom Statistics don't show up in HUD

Postby SakisLam » Sun Apr 01, 2012 6:44 am

I've made a bit of a research and I came across the same problem ( https://na4.pokertracker.com/forums/vie ... 2&p=113431 ) and the same workaround works also for me, but Im wondering if there's a more straightforward way thats been developed since then, since Im trying to create a lot of custom stats and duplicate all of them would be a bit time consuming. Thanks!
SakisLam
 
Posts: 22
Joined: Wed Feb 27, 2008 3:13 pm

Re: Custom Statistics don't show up in HUD

Postby kraada » Sun Apr 01, 2012 8:15 am

What kind of custom formatting are you looking to do?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom Statistics don't show up in HUD

Postby SakisLam » Sat Apr 21, 2012 7:54 am

blnds_20_bb_hands = sum(if[tourney_holdem_hand_player_statistics.id_hand > 0 AND tourney_holdem_blinds.amt_bb = 20 AND position = 8, 1, 0]) in Columns, Holdem tournament player statistics.
SakisLam
 
Posts: 22
Joined: Wed Feb 27, 2008 3:13 pm

Re: Custom Statistics don't show up in HUD

Postby WhiteRider » Sat Apr 21, 2012 8:38 am

That shouldn't be necessary for an expression like that - the Variable workaround is only needed for text stats like those using the Player name.

Here you should only need the following as a column - you don't need to check the hand ID.

sum(if[tourney_holdem_blinds.amt_bb = 20 AND position = 8, 1, 0])
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 1 guest