Variables in Reports

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

Variables in Reports

Postby PJs Ronin » Wed Mar 09, 2011 2:12 am

General question: Is is possible to create a temp variable in a report. Say, create var 'temp' and make 'temp' count the number of times something else happened. Say, count the number of times M > 10 (for a tourney report)?

Specific question: In this report there is a stat "EV Allin Equity". How can I filter on this stat... perhaps for the value to be greater than zero. Obviously, I'm trying to clean up this report.
[ img ]
PJs Ronin
 
Posts: 978
Joined: Fri Dec 25, 2009 11:55 pm

Re: Variables in Reports

Postby WhiteRider » Wed Mar 09, 2011 4:50 am

PJs Ronin wrote:General question: Is is possible to create a temp variable in a report. Say, create var 'temp' and make 'temp' count the number of times something else happened. Say, count the number of times M > 10 (for a tourney report)?

I don't think that you can do that sort of thing in a variable – you would need to build a new column to check for M in the specific hand being greater than 10. The column would be Summary Type "count".
You could display this in a stat as a checkbox [format expression: format_bool(m_over_10,'check') ] and have the Format Summary Expression display the count:
format('{1} M>10', m_over_10)

Specific question: In this report there is a stat "EV Allin Equity". How can I filter on this stat... perhaps for the value to be greater than zero. Obviously, I'm trying to clean up this report.

That seems to be the same issue we were discussing here? if I don't have any additional information at the moment.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Variables in Reports

Postby PJs Ronin » Wed Mar 09, 2011 7:20 pm

WhiteRider wrote:
PJs Ronin wrote:Specific question: In this report there is a stat "EV Allin Equity". How can I filter on this stat... perhaps for the value to be greater than zero. Obviously, I'm trying to clean up this report.

That seems to be the same issue we were discussing here? if I don't have any additional information at the moment.

No... just trying to come at this from a different angle.
PJs Ronin
 
Posts: 978
Joined: Fri Dec 25, 2009 11:55 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests