Is it Possible to Distinguish Merge Skins?

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

Re: Is it Possible to Distinguish Merge Skins?

Postby sfifield » Mon Nov 19, 2012 1:47 am

sfifield wrote:Thanks. I was able to create a new column, amt_rakeback_merge, for Merge rakeback:

Code: Select all
sum(if[holdem_hand_summary.id_site=2100 and holdem_hand_player_statistics.id_player_real = 387595, 0.35, 0] * 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])

The new stat for Amount Won w/Rakeback was "amt_won + amt_rakeback_merge" and it shows up in reports and graphs correctly. (When I built the stat from existing columns, it would show up in reports, but I couldn't add it to the graph).


For some reason, my custom stat Amount Won w/Rakeback is now broken by a recent update. The individual components (i.e., "amt_won" and "amt_rakeback_merge" appear to function properly, but I get weird and incorrect values for the stat that is defined as "amt_won + amt_rakeback_merge." Any idea what might be causing this issue (and how to fix it)?
sfifield
 
Posts: 31
Joined: Sun Apr 04, 2010 4:24 pm

Re: Is it Possible to Distinguish Merge Skins?

Postby kraada » Mon Nov 19, 2012 9:35 am

I don't see anything in the latest beta version that would affect this. Please post a screenshot of a report showing all three values (amount won, rakeback, amount won + rakeback) to a support ticket and we'll look into this for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Is it Possible to Distinguish Merge Skins?

Postby sfifield » Mon Nov 19, 2012 9:37 pm

Thanks. It turns out that for some reason, the "sum results" box was unchecked in the overlay stats popup. Problem fixed. Sorry for the trouble.
sfifield
 
Posts: 31
Joined: Sun Apr 04, 2010 4:24 pm

Previous

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

Who is online

Users browsing this forum: No registered users and 3 guests