Custom Column & Stats won't show up on any table/report

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 Column & Stats won't show up on any table/report

Postby jerr24jerr » Thu Oct 16, 2008 2:49 am

Hello,

I am new to PT3 and I'm trying to use the custom stats feature. I want to know how many hands went to showdown when a player has raised the preflop. The custom column I add to Player statistics is:

Code: Select all
name: cnt_hnd_p_raise
exp: sum( if[ holdem_hand_player_statistics.cnt_p_raise > 0 , 1, 0])


there is no problem here. I also add successfully in the Statistics tab:

Code: Select all
name: Hands Raised
exp: cnt_hnd_p_raise


I want to see the results of the new statistics I add, I create a report with one column playername and another column with total hands played and a third column as my newly created statistics "Hands Raised". However when I run the report only the first two columns appear and the third column is not there. I have tried restarting PT3, housekeeping on database. I have also created a couple of other custom stats the same way, the result is the same. The columns won't appear in any table/report.

I don't know what I'm doing wrong. Maybe it is my illiteracy about this program.

Thanks for the help.
jerr24jerr
 
Posts: 4
Joined: Thu Oct 16, 2008 2:30 am

Re: Custom Column & Stats won't show up on any table/report

Postby WhiteRider » Thu Oct 16, 2008 5:06 am

You need to go to the Statistics -> Format tab and enter info for the column 'Title' and 'Width' (at least).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom Column & Stats won't show up on any table/report

Postby jerr24jerr » Thu Oct 16, 2008 9:59 am

Thank you for the reply. It worked.
jerr24jerr
 
Posts: 4
Joined: Thu Oct 16, 2008 2:30 am


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

Who is online

Users browsing this forum: No registered users and 1 guest