kraada wrote:About Rakeback first:
.......
Therefore, your rakeback needs to be calculated for each individual hand. This is why the stat cannot be used in the Player Summary report - that report uses details only available on whole sessions. But you cannot calculate your rakeback using session values if you want it to be accurate.
However, the stat can be used on the Player Statistics report on the General tab. It's not on the same line, I know, but it will still be grouped by the same limits so you can see how you are doing on the same screen.
The calculation used in the column is:
sum(if[holdem_hand_player_detail.amt_bet_ttl > 0, (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, 0])
For each hand, if you bet anything this adds your percentage of the pot (your total bet divided by the final pot) times the rake to your weighted contributed rake. The multiplication by rakeback percentage is then done in the statistic itself.
....
Kraada-
Is there a way to join the session data to the hand data? If so, although it would require new columns in te db, couldn't you for a session then do a sumif on sess #?
There must be a relationship between a hand # and a session... or rather a way to list all hands for a session, since session hands lists all hands for a session.
What is that relationship, and could you therefore create RB by session by summing all those hands? (And if not why not, I Must be missing something...)