Number of players / Blinds level

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

Number of players / Blinds level

Postby jackh69 » Sat Oct 10, 2009 11:02 am

Hi,

It's possible to add the number of players (average) for each blinds level (Sit'n Go) ?

Thanks :ugeek:
jackh69
 
Posts: 14
Joined: Tue Sep 29, 2009 8:21 pm

Re: Number of players / Blinds level

Postby kraada » Sat Oct 10, 2009 11:07 am

Where do you want to add this?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Number of players / Blinds level

Postby jackh69 » Sat Oct 10, 2009 11:13 am

kraada wrote:Where do you want to add this?

General / Player Statistics where you have : Blinds - Hands - Amount Won - VPIP ....
I want to know the number of remaining players by level of Blinds, when the bubble starts etc.

:ugeek:
jackh69
 
Posts: 14
Joined: Tue Sep 29, 2009 8:21 pm

Re: Number of players / Blinds level

Postby kraada » Sat Oct 10, 2009 11:40 am

Okay, so what you want to do is to build a stat that shows average number of players in a hand, and then when you add it into that report, it will get split up by blind level automatically.

To build average number of players in a hand, click Configure --> Configure Statistics, go to the Holdem Tournament Player Statistics section and create a new column, call it cnt_player_total, with definition:
sum(tourney_holdem_hand_summary.cnt_players)

Then go to the Statistics section and create a new stat and call it Average Players, with definition:
(cnt_player_total / cnt_hands) * 100

Give it a description you like, fill in the format tab, apply, add the stat to your report and you should be all set.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Number of players / Blinds level

Postby jackh69 » Sat Oct 10, 2009 12:17 pm

It's perfect. Thanks you. 8-)
jackh69
 
Posts: 14
Joined: Tue Sep 29, 2009 8:21 pm

Re: Number of players / Blinds level

Postby kraada » Sat Oct 10, 2009 12:28 pm

You're very welcome :ugeek:
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 0 guests