Number of hands won per each session

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 hands won per each session

Postby TTR85447932 » Tue Mar 29, 2011 11:13 am

Hello, I would like to have statistic hands won in section Sessions. This statistic is included only in General. What could I do to see number of hands won per each session?
TTR85447932
 
Posts: 21
Joined: Wed Jul 23, 2008 4:10 am

Re: Number of hands won per each session

Postby kraada » Tue Mar 29, 2011 11:44 am

You'll need to create a custom statistic in the Holdem Cash Session section, but this is certainly a statistic you can create.

Create a new column called cnt_hands_won with definition sum(holdem_table_session_summary.cnt_hands_won) and then create the statistic on the stats tab to just display that value and you'll be able to add the new stat to that report straight away (don't forget to fill in the Format tab though!).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Number of hands won per each session

Postby TTR85447932 » Tue Mar 29, 2011 5:49 pm

It helps me alot (saved half day working). Finally I have made my first own statistic. Thank you!
TTR85447932
 
Posts: 21
Joined: Wed Jul 23, 2008 4:10 am

Re: Number of hands won per each session

Postby kraada » Wed Mar 30, 2011 8:37 am

You're welcome :)
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 2 guests