Number of players at table?

[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.

[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".

[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?

[WhiteRider]

For analysis afterwards you can access the number of players in a hand using the database field "tourney_holdem_hand_summary.cnt_players".

[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.

[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).

[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?

[kraada]

That does sound odd. Do the normal reports work fine for you?

[cag8f]

Do you mean the built-in reports displayed in General, Hands, Tournaments, etc tabs? If so, then yes, those work without issue.

[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.