winrates report?

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

winrates report?

Postby waffe7 » Fri Dec 09, 2011 6:34 pm

Is there a way to make a report of all users over X hands winrates in a certain DB, or across several DBs? I know how to do it for the current user, but wanted to do this over a large number of players.
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: winrates report?

Postby kraada » Fri Dec 09, 2011 6:50 pm

Create your report in the Reports tab and in the blue Filters section uncheck "Filter on Active Player" - then you'll be able to see data on all players.

You can't filter across multiple databases, but you can look at all users in whatever database you have active.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: winrates report?

Postby waffe7 » Sat Dec 10, 2011 3:59 pm

Cool thanks. This works, but just has a single winrate for everyone, is there any way to get a report of winrate by player?
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: winrates report?

Postby kraada » Sat Dec 10, 2011 4:06 pm

If you add the Player stat it will break down the report into one row per player in your database.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: winrates report?

Postby waffe7 » Sat Dec 10, 2011 4:10 pm

Worked, thanks!
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm


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

Who is online

Users browsing this forum: No registered users and 3 guests