accessing stats of groups of 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

accessing stats of groups of players

Postby Dave2020 » Tue Oct 26, 2010 2:03 am

Hi.
I recently autorated all of the players in my database. I have only 3 player types that are defined by very narrow sets of rules, so that only 1% or so of my entire database is rated. My intention is to put all of the hand histories of each different player type into 3 different groups. In the end I'd like to be able to reference each group individually and pull out stats as averages of each group.

I hope that made sense. If so, is it possible?
Any help will be greatly appreciated...
Dave2020
 
Posts: 6
Joined: Fri Mar 27, 2009 1:11 pm

Re: accessing stats of groups of players

Postby gkeuler » Tue Oct 26, 2010 3:13 am

think this could be done by creating the report like normal, then within the reports tab click filters, uncheck "Filter on active player", adding and saving " Select player.val_icon=X " See bloodndef's post below for the values of 'X'.

then duplicate the report and edit the value of 'X' for each player type, the summary bar on the bottom of each group will tell you the averages for each report

bloodndef wrote:To call up the icon value in a Holdem Cash Player Statistics report, I use:

Select player.val_icon = X

Where X is a number between 0 -14.

val_icon has a value of 0-14; the 0-14 signifies an AR icon type.


0 = 'Default' Blue Man Icon
1 = Fish Icon
2 = Green Money Bag Icon
3 = Yellow Smiley Face Icon
4 = Green Frown Face Icon
5 = Yellow Yield/Exclamation Point Sign Icon
6 = Bomb Icon
7 = Red Dice Icon
8 = Rock Icon
9 = Tornado Icon
10 = Yellow Square Question Mark Icon
11 = Phone Icon
12 = Mouse Icon
13 = Elephant Icon
14 = Eagle Icon
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: accessing stats of groups of players

Postby Dave2020 » Tue Oct 26, 2010 9:10 pm

One of the three ratings I have uses the eagle icon (#14) so I ran the first report substituting "X" for "14". Players that were given the eagle icon are supposed to have a VPIP between 19 and 24 (according to the rules I made). When I got the results for the report I ran the VPIP came out at 27.63. The PFR stat was also off (it was much lower). I wondered if the report was maybe using the default rules for player ratings rather than the ones I made up...

I ran another report, this time substituting "X" for "6", the number of the bomb icon which I don't even use. The report ran for a bit then gave me the same numbers from the last report.

Another thing I realized is that I might not even have any players in my database that fit into the rules for the other two icons I made. Seems like only a few eagles came out with a rating. Not sure if that has to do with anything...

Any idea what's going wrong??
Dave2020
 
Posts: 6
Joined: Fri Mar 27, 2009 1:11 pm

Re: accessing stats of groups of players

Postby kraada » Wed Oct 27, 2010 8:52 am

That's odd - did you add any other filters to the filter list? What stats did you add to the display?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: accessing stats of groups of players

Postby Dave2020 » Wed Oct 27, 2010 3:03 pm

No other filters.

Stats for the report are VP$IP, VP$IP-c, PFR, PFR-c, RWPC-c, Att To Steal-c, SB Call Steal, BB Call Steal, Fold to Steal, etc.
(Thanks for your HUD by the way :) )

The Section of the report should be "Holdem Cash Player Statistics" correct?
Dave2020
 
Posts: 6
Joined: Fri Mar 27, 2009 1:11 pm

Re: accessing stats of groups of players

Postby kraada » Wed Oct 27, 2010 3:58 pm

You're welcome, and that should be working. Could you export the report and attach it to a support ticket so we can investigate further? In my own tests these have worked just fine for me.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: accessing stats of groups of players

Postby Dave2020 » Wed Oct 27, 2010 6:14 pm

Just sent the report file via support ticket
Dave2020
 
Posts: 6
Joined: Fri Mar 27, 2009 1:11 pm

Re: accessing stats of groups of players

Postby kraada » Wed Oct 27, 2010 6:19 pm

Thanks, we'll take a look and get back to you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests