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 mtagliaf » Wed Dec 03, 2008 11:16 am
My ITM calc is going nuts now because of the new matrix tourneys. A decent player usually wins some money in the matrix tourneys, so my ITM is really high (example: I won $3.90 in a $5 + .50) tourney today.
I'm wondering if there's a way to create a "non matrix tourney" counter and then a new ITM stat that doesn't include the matrix tourneys.
(money won in non matrix tourneys) / (# of non matrix tourneys)
-
mtagliaf
-
- Posts: 45
- Joined: Tue Feb 12, 2008 10:30 pm
by WhiteRider » Thu Dec 04, 2008 6:04 am
You may be able to do this with a Custom Stat by checking the tournament name if it includes something specific.
Have a look at the
Custom Statistics and Reports FAQ.
Or possibly the buy-in amount is different? If so, you could use the filters button and filter for NOT the buy in amount.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests