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 hexilumhexus » Mon Mar 08, 2010 10:49 pm
I've categorized every player under an icon governed by the auto-rate rules. My goal is to display the average bb/100 of every icon for a specific limit game. Is this possible?
Ex.
L-PP -> avg. bb/100
L-AP -> avg. bb/100
L-PA -> avg. bb/100
L-AA -> avg. bb/100
T-PP -> avg. bb/100
T-AP -> avg. bb/100
T-PA -> avg. bb/100
T-AA -> avg. bb/100
-
hexilumhexus
-
- Posts: 2
- Joined: Wed Feb 17, 2010 8:19 am
by kraada » Tue Mar 09, 2010 9:50 am
If you create a custom statistic in the HCPS section to group by val_icon, you should be able to create this as a custom report - see the
Tutorial: Using Custom Statistics and Reports for more on how to create custom reports.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests