custom stats to exclude matrix tourneys from ITM calc

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

custom stats to exclude matrix tourneys from ITM calc

Postby 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

Re: custom stats to exclude matrix tourneys from ITM calc

Postby 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]

Who is online

Users browsing this forum: No registered users and 0 guests