Reports by tournament size

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

Reports by tournament size

Postby Rycky4Golf » Sun Oct 18, 2009 10:49 am

Where would I go to either define a report or make one where I could group all my games by the number of entrants? I want to do this for bankroll management purposes. I'd like to see a report where I can see how much in buy-ins I've spent when the field size is between a certain number of players, whether its done on one report or I have to create one for each, I don't care. For example, I want to know how much I buy in for when the field sizes are from 1-10 players, then 11-50, 51-90, 91-180, 181-360, and 361 or more.

Any help would be greatly appreciated!
Rycky4Golf
 
Posts: 30
Joined: Tue Jun 10, 2008 12:55 pm

Re: Reports by tournament size

Postby WhiteRider » Sun Oct 18, 2009 11:49 am

You could do this by creating a custom stat in the Holdem Tournament Tournament section, which would show which group/range of entrants each tournament is in.

The attached report should do the trick, although I've only created the first couple of categories - you'll have to add the others yourself.

Extract the report file from the zip file and import it on the Tournaments > Reports tab.
Custom Report and Statistic tutorial.
Attachments
HTTs - Field Size.zip
(705 Bytes) Downloaded 112 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Reports by tournament size

Postby Rycky4Golf » Sun Oct 18, 2009 1:07 pm

I'm a noob at this... I got the report fine but I'm not sure where to go or how to add those other fields.
Rycky4Golf
 
Posts: 30
Joined: Tue Jun 10, 2008 12:55 pm

Re: Reports by tournament size

Postby WhiteRider » Sun Oct 18, 2009 1:27 pm

You will need to add more cases to the Format Expression of the Field Size stat, and to the id_field_size column that it uses.
Have a look at the tutorial I linked for you, which explains how to work with custom stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Reports by tournament size

Postby Rycky4Golf » Sun Oct 18, 2009 5:38 pm

Took some trial and error since I had no idea what you were talking about, but I got it done. Thanks. :)
Rycky4Golf
 
Posts: 30
Joined: Tue Jun 10, 2008 12:55 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests