Average Saw Flop %

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

Average Saw Flop %

Postby Ixiterra » Thu Jan 28, 2010 6:31 am

This was a stat in PT2 that I can not seem to find in PT3. On the summary screen, it showed the average number of players seeing the flop as a percentage. As a percentage and as just a number would be nice in PT3. Am I missing it somewhere?
Ixiterra
 
Posts: 20
Joined: Sun Nov 15, 2009 1:26 pm

Re: Average Saw Flop %

Postby WhiteRider » Thu Jan 28, 2010 6:37 am

There is a "Players to Flop" stat available for download from the Repository, posted by me.
You can add this to the Cash Games > Sessions > Sessions by Table report.

Tutorial: Configure Built-in Reports
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Average Saw Flop %

Postby Ixiterra » Thu Jan 28, 2010 7:06 am

I searched for "players flop" and didn't find anything. Might want to work on the search functionality a little bit. :) thanks though
Ixiterra
 
Posts: 20
Joined: Sun Nov 15, 2009 1:26 pm

Re: Average Saw Flop %

Postby Ixiterra » Thu Jan 28, 2010 7:54 am

Also, I can't seem to get this working. It only shows up under the "player summary" section on the general tab, and it shows 0.0 for everything.
I tried adding it to "Holdem Cash Session" vs "Holdem Cash Sessions" (which allows it to show up on the sessions tab) and that gives me an SQL execution error.
Ixiterra
 
Posts: 20
Joined: Sun Nov 15, 2009 1:26 pm

Re: Average Saw Flop %

Postby WhiteRider » Thu Jan 28, 2010 8:39 am

Ah, sorry - I forgot.. There is a known issue with this: the database field which stores the number of players that saw the flop over a whole session is not populated correctly, so this stat won't currently work.
This issue is in our bug tracker and I'll bump it to the development team again.
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 0 guests