Reports on different players

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

Reports on different players

Postby chipix » Fri Jun 01, 2012 6:25 am

Is it possible in PT3 to get reports for different players?
For example I would like to find the players that I have played more than 1000 hands or the players that I have encountered on most tournaments.
chipix
 
Posts: 8
Joined: Fri Feb 17, 2012 2:33 am

Re: Reports on different players

Postby kraada » Fri Jun 01, 2012 9:05 am

Yes, you can see a different player's statistics by choosing them on the sidebar on the left.

Your report to see lots of players at once can be done on the Reports tab. Create your report in the Player Statistics section, in the blue Filters link uncheck Filter on Active Player, and add the stats Player and Hands. Then you'll see a list of all players and the number of hands you have on them. You can add more stats as you wish, and you can filter further down in the blue Filters section based on the statistics of all players (if you insert a stat there it checks to make sure all people have the value specified - so #Hands# > 1000 requires more than 1000 hands on each player, etc.).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Reports on different players

Postby chipix » Fri Jun 01, 2012 9:19 am

Thx got it.
How do I filter out myself?
I tried the filter #Player#!="myname" but it does not pass validation.
chipix
 
Posts: 8
Joined: Fri Feb 17, 2012 2:33 am

Re: Reports on different players

Postby kraada » Fri Jun 01, 2012 11:48 am

Use:

player.player_name != 'Your Screen Name'

(and you do need quotes around your screen name) and that should do it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Reports on different players

Postby ElloraBoy » Sat Sep 29, 2012 7:06 pm

I am trying to create a similar Report. Is it possible to do it with tournaments played instead of hands and to have a column for ROI or 'in the money %' ?
I would like to see which players have a good ROI over a decent sample size so I can add that to my notes.
ElloraBoy
 
Posts: 1
Joined: Mon May 10, 2010 12:53 am

Re: Reports on different players

Postby WhiteRider » Sun Sep 30, 2012 4:53 am

Yes - to display this kind of information you need to create your report in the Holdem Tournament Tournaments section.
To filter for number of tournaments enter this as a filter expression:

cnt_tourneys > 10

(or whatever number).
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 7 guests

cron