Allin Preflop - What am I doing wrong?

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

Allin Preflop - What am I doing wrong?

Postby Josiah » Thu Jul 19, 2012 8:50 pm

Hi, I want to know the % that a player shoves preflop

In Holdem Tournmanet Player Statistics I created the column cnt_p_allin as:
sum( if[ tourney_holdem_hand_player_statistics.enum_allin = 'P',1,0])

And the Statistic Allin Preflop as:
(cnt_p_allin / cnt_hands) * 100

I updated the cache, added the stat to the HUD and played a couple of S&Gs on Titan. Players did shove preflop but this never updated on the HUD.

What am I doing wrong?

I have another stat which is not working as well, but maybe I can fix that myself once I understand the problem here.

Thanks
Josiah
 
Posts: 55
Joined: Sat Aug 30, 2008 8:36 pm

Re: Allin Preflop - What am I doing wrong?

Postby WhiteRider » Fri Jul 20, 2012 3:45 am

At first glance I can't see why that wouldn't work. Please export your stat and attach it to a Support Ticket along with the hand history file for the tournament in question so that we can investigate.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Allin Preflop - What am I doing wrong?

Postby Josiah » Fri Jul 20, 2012 10:30 pm

It is working now. So is the other stat. The only thing I did was restart everything.
Josiah
 
Posts: 55
Joined: Sat Aug 30, 2008 8:36 pm

Re: Allin Preflop - What am I doing wrong?

Postby kraada » Sun Jul 22, 2012 9:26 am

I'm glad to hear it's working now - thanks for following up!
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