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
by 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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 3 guests