Last X Minutes Stats

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

Last X Minutes Stats

Postby xbit » Tue Nov 25, 2008 6:11 pm

In PT2 was option like a Display Stats for Last N Hands for HUD. It is really important for Heads-Up poker becouse Dinamics is more useful then Statistics. But in PT3 i cant find how to do it...

WhiteRider wrote:I can't think of a way of doing the last X hands off the top of my head, but you could add a check for hands played since a date, for instance, using database field:
holdem_hand_summary.date_played


But we can use time and add some code to columns for recieving Stats margin with Last X Minutes... something like that
"if( ... AND (holdem_hand_summary.date_played.time + 15 minutes > current.time), ...) "
But how to write this part of Expression correctly?
xbit
 
Posts: 32
Joined: Fri Feb 22, 2008 9:47 pm

Re: Last X Minutes Stats

Postby xbit » Tue Nov 25, 2008 6:38 pm

UDP: "sum(if[ ... AND (holdem_hand_summary.date_played.time + 15 minutes > current.time), ...]) "
xbit
 
Posts: 32
Joined: Fri Feb 22, 2008 9:47 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests