Can someone help me with a Simple custom stat?

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

Can someone help me with a Simple custom stat?

Postby PaleTokio » Mon Nov 22, 2010 6:53 am

Hey people.
I was thinking of a stat in the winning tab where i could put a "Winning per month average stat" Total won/months played?
Pleeeease pretty please this would make our analisis much better.
Dont know if this stat is already there, if it is please advice me.
TY for reading :)
PaleTokio
 
Posts: 4
Joined: Tue Aug 25, 2009 9:17 pm

Re: Can someone help me with a Simple custom stat?

Postby PaleTokio » Mon Nov 22, 2010 6:54 am

or report, whatever :D
PaleTokio
 
Posts: 4
Joined: Tue Aug 25, 2009 9:17 pm

Re: Can someone help me with a Simple custom stat?

Postby kraada » Mon Nov 22, 2010 10:12 am

Yes this can be done. Click Configure --> Configure Statistics. Go to the Holdem Cash Sessions section and go to the Columns tab. Duplicate amount won, call the new one amt_won_avg, and change Summary Type to Average and save it. Go to the Statistics tab. Duplicate the Amount Won statistic, change all references to amt_won to amt_won_avg (on the Definition and Format tabs), change the name as you'd like and save it and apply the changes. Then go to your Winnings By Month report and click the small wrench at the top right and add your new statistic and it should show amount won for each row but the summary line will give you the average amount won over the months displayed.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can someone help me with a Simple custom stat?

Postby PaleTokio » Mon Nov 22, 2010 11:22 pm

Its working!! ty ty tyvm dude. Ill send you $500 when Im a millionare :D
PaleTokio
 
Posts: 4
Joined: Tue Aug 25, 2009 9:17 pm

Re: Can someone help me with a Simple custom stat?

Postby kraada » Tue Nov 23, 2010 9:41 am

I'll hold you to that :D
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 5 guests