Page 1 of 2
Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Sat Nov 09, 2013 3:20 pm
by cag8f
I'm trying to create a new statistic that uses the current number of players at the table for a given hand number. In what section and column can I find this value? I'm tired, so it might be right under my nose.
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Sat Nov 09, 2013 3:42 pm
by WhiteRider
That can be done with the live stats mechanism. Is this for PT3 or PT4?
If it's PT4 take a look at how the other stats beginning with "Live" for how to make live stats. The number of players is "live_cash_table.cnt_players".
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Sat Nov 09, 2013 10:26 pm
by cag8f
I'm using PT3. Since this is done with Live Stats, am I correct that I cannot access this information offline? I'd like to perform an analysis of all my previous SNGs. Specifically, I'd like to calculate my average stack when the bubble bursts (i.e. when the number of players at the table becomes 3). Is this possible?
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Sun Nov 10, 2013 6:21 am
by WhiteRider
For analysis afterwards you can access the number of players in a hand using the database field "tourney_holdem_hand_summary.cnt_players".
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Thu Nov 14, 2013 11:36 am
by cag8f
Thanks. But in what 'Section' can I find this data? In PT3, when creating a new statistic, I have to choose a section, and I can't find "tourney_holdem_hand_summary.cnt_players" in any of the 4 "Holdem Tournament" sections (Holdem Tournament Hand, Holdem Tournament Player Statistics, Holdem Tournament Tournament, or Holdem Tournament Tournaments). I can find "tourney_holdem_summary.cnt_players," but that appears to just be the total number of players that entered each tourney.
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Thu Nov 14, 2013 2:42 pm
by kraada
You can filter by its value in the blue Filters link of a custom report on the Reports tab, just enter the inequality representing the value you want (this will work for Hand or Player reports).
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Tue Nov 19, 2013 9:55 am
by cag8f
Sorry I'm still trying to get this to work. I'm stumbling over my first hurdle though: getting a report to run in the Holdem Tournament Hand section. I've created a simple report that only includes the "Player" statistic. I have the "Filter on Active Player" box checked. Shouldn't this report return my player name? It returns nothing. (FYI, if I uncheck 'Filter on Active Player,' a list of all player names *is* returned) Furthermore, when I try to add the "Chips" statistic, and filter to only hands with 3 players at the table, the report runs for about 30 seconds, then I receive an error stating, "Unable to execute query...Reason: Fatal Error (out of memory for query result). I have about 27k total hands, running Win 7 32 bit, and have 3GB of RAM. Thoughts?
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Tue Nov 19, 2013 10:32 am
by kraada
That does sound odd. Do the normal reports work fine for you?
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Tue Nov 19, 2013 10:37 am
by cag8f
Do you mean the built-in reports displayed in General, Hands, Tournaments, etc tabs? If so, then yes, those work without issue.
Re: Number of players at table?
![Post Post](https://www.pokertracker.com/phpBB3-forums/styles/prosilver-embed/imageset/icon_post_target.gif)
Posted:
Tue Nov 19, 2013 12:13 pm
by kraada
Try adding some of the stats for any of the reports that show one hand per row. Like "Hand #" -- those are all Hand statistics and those reports should work the same as the custom Hand reports.