Contributed rake

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

Contributed rake

Postby voffa4ka » Mon Nov 16, 2009 8:14 pm

Hello,
I wrote a stat, that calculates contributed rake for one played hand:

holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot

(this method is used by many sites in RB calculation)

Could you help me write a stat, that summarizes contributed rake values for all played hands during ONE session.

Sum() function works well, but it summarizes contributed rake values for all played hands ever. And I wanna get separate values for different sessions.
voffa4ka
 
Posts: 1
Joined: Mon Nov 16, 2009 7:46 pm

Re: Contributed rake

Postby WhiteRider » Tue Nov 17, 2009 5:18 am

You can't build this kind of stat in the Holdem Cash Session section because it is built from individual hands (and stats in that section are built from session information, not hand information).

You can build it in the Holdem Cash Player Statistics section, and use my "HCPS Session statistics" report from the Repository to display the total for each session.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests