by kraada » Fri Jun 01, 2012 9:30 am
I see what happened here.
You can fix this manually by clicking Configure --> Statistics, and in the $ Players Columns area search for merge - there should be only one match. Replace the column with this definition:
sum(CAST( (if[cash_hand_player_statistics.amt_bet_ttl > 0 and cash_hand_summary.id_site = 2100, cash_hand_player_statistics.val_curr_conv * .35 * (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake, 0]) AS numeric(11,2) ))
And save it. Then you should see the right values. I'll update the stats in the Warehouse now.
In the stat back was My Currency Net Won + Rakeback (Merge) - you can use that stat on the graph by clicking the blue Configure link next to Show Stats and adding My CUrrency Net Won + Rakeback (Merge). You want to Sum Results for that stat to make it display properly and then you should get the line you want to see.