Average of the averages?

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

Average of the averages?

Postby Lars11 » Sat Jul 10, 2010 11:00 pm

Anyone can tell me how I retrieve average stats from the whole Database?
E.g the average preflopraise among "my" players?

Cant seem to find it.

Thanks
Lars11
 
Posts: 36
Joined: Sun Apr 13, 2008 9:24 pm

Re: Average of the averages?

Postby WhiteRider » Sun Jul 11, 2010 5:00 am

You can see that on the Summary tab - you can add other stats to the report if you like.
Tutorial: Configure Built-in Reports

Alternatively you could use a Custom Report in the Holdem Cash Player Statistics section.
Tutorial: Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Average of the averages?

Postby Lars11 » Sun Jul 11, 2010 11:30 am

Great! Worked fine.

Just need to know how I limit the number of hands (couldnt find it in filters)?
Lets say I only want to check out players with a minimum of 2000 hands in my database...

Thanks
Lars11
 
Posts: 36
Joined: Sun Apr 13, 2008 9:24 pm

Re: Average of the averages?

Postby WhiteRider » Sun Jul 11, 2010 12:16 pm

You would need to use a custom report for that. You can add a custom filter of:
#Hands# > 2000

See the Tutorial: Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Average of the averages?

Postby Lars11 » Mon Jul 12, 2010 5:20 pm

Got it now.
Thanks
Lars11
 
Posts: 36
Joined: Sun Apr 13, 2008 9:24 pm


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

Who is online

Users browsing this forum: No registered users and 2 guests