my session stats

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

my session stats

Postby Th0rgal » Thu Aug 27, 2009 3:19 am

Hi there,

Is it possible to get your VP/PFR and AF for eaxh session under the session tab? Or is there a way to just filter on a session?

Thank you,
Thor
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: my session stats

Postby WhiteRider » Thu Aug 27, 2009 4:35 am

On the Sessions tab if you double click a session the other reports will be filtered to that session.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: my session stats

Postby Th0rgal » Thu Aug 27, 2009 7:58 am

Clever Thanks
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: my session stats

Postby Th0rgal » Thu Aug 27, 2009 12:08 pm

Is there a way of getting this in a report for all my sessions?
Example
Session 1 VP PFR AT ETC BB/100
Session 2
Session 3

Thanks
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: my session stats

Postby WhiteRider » Thu Aug 27, 2009 12:52 pm

That's more difficult.
The Sessions report itself is built from session totals not individual hands, so you can't show those kind of stats.

You could probably do something approaching this in a custom report by adding table-name and date played stats (which would need building).
I've got a couple of ideas to try, but I'll have to do it later when I have some time - I'll get back to you.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: my session stats

Postby WhiteRider » Fri Aug 28, 2009 10:36 am

It turns out that this is quite straightforward to do in a custom report.
It needs one simple new custom statistic to display the start time of a session.

The report is going to be in the Holdem Cash Player Statistics section so that you can view the stats that you want, so the new stat needs to be in that section too.

Create a new Column called "date_session_start" with the Expression:
holdem_table_session_summary.date_start
Enable the "Group By" option and set the Summary Type to 'Count Unique'. 'Group By' means that all hands for which the session started at the same time will be grouped together into a single row in the report.
Click 'Save'.

Now create a new Statistic called "Session Start" with the name of the new column in the Value Expression:
date_session_start
On the Format tab set the Title ("Session Start") and Width (120). You can leave the Format Expression blank but set the Format Summary Expression field to:
format( '{1} sessions', date_session_start )
On the Categories tab select just Time Played.
Click 'Save' and 'Apply' to create the stat.

(For examples and walkthroughs of this process please see the Custom Statistics and Reports FAQ.)

Now on the Cash Games > Reports tab select the 'Holdem Cash Player Statistics' section and click New to create a new report.
Give it a name ("Session Stats", maybe).
Add the new "Session Start" stat along with any other stats you'd like to see - Limit, Hands, VP$IP, PRF, etc.
You might want to add a date filter if you have played a lot of sessions so that the report isn't too big.
Run your report and you should see one row for each session displaying the stats.

I have attached my report here and I'll upload it to the Repository too - this will include the new "Session Start" stat described above.
Attachments
HCPS - Session Stats.zip
(1.21 KiB) Downloaded 1000 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: my session stats

Postby meliniak » Thu Dec 31, 2009 11:25 pm

WhiteRider wrote:It turns out that this is quite straightforward to do in a custom report.

Works very nice. Can you share any ideas how to do the same for time session, not for each single table session?

WhiteRider wrote:On the Sessions tab if you double click a session the other reports will be filtered to that session.

Is this suppose to work in PT3 build 3? Double-clicking on a session doesn't work for me.
meliniak
 
Posts: 14
Joined: Thu Dec 31, 2009 11:15 pm

Re: my session stats

Postby WhiteRider » Fri Jan 01, 2010 7:04 am

meliniak wrote:
WhiteRider wrote:It turns out that this is quite straightforward to do in a custom report.

Works very nice. Can you share any ideas how to do the same for time session, not for each single table session?

I can't think how you would do that - it might be possible but it would be significantly more complicated.

WhiteRider wrote:On the Sessions tab if you double click a session the other reports will be filtered to that session.

Is this suppose to work in PT3 build 3? Double-clicking on a session doesn't work for me.

Build 3 is very old now and you really need to update - there are many, many bug fixes and new features since Build 3.

Download page
PT3 Build History / Release Notes
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: my session stats

Postby meliniak » Fri Jan 01, 2010 3:57 pm

Ok, thank you very much for the answer. Happy new year btw :)
meliniak
 
Posts: 14
Joined: Thu Dec 31, 2009 11:15 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest