Number of Days played with more than 125 FTP

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

Number of Days played with more than 125 FTP

Postby swizz » Fri Dec 24, 2010 4:56 am

Hello,

i have the Stat Base_FTPs with

sum(if[holdem_hand_summary.amt_rake > 0, (holdem_hand_summary.amt_rake * 10) / holdem_hand_summary.cnt_players, 0])

and the stat number_of_daysplayed
count( distinct dateextract_date[datefix_fromutc[holdem_hand_player_statistics.date_played]] )

Could you maybe help me to combine this stats, to a stat which only count the days on which i made more than 125 FTP. I have no idea, how i could do this.

regards
Swizz
swizz
 
Posts: 17
Joined: Thu May 15, 2008 5:07 pm

Re: Number of Days played with more than 125 FTP

Postby kraada » Fri Dec 24, 2010 9:43 am

The easiest way to do this is actually with a custom report. Create your report in the Holdem Cash Player Statistics section, and in the blue Filters section add the filter: #Base FTPs# > 125. Make sure it filters on active player, then unzip, import, and add the attached stat (MonthDayYear) to the report - that will break your report down into days, and the filter will filter only to days where you had more than 125 base FTPs. The total count of days will be listed at the bottom of the report.
Attachments
MonthDayYear.zip
(675 Bytes) Downloaded 96 times
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 1 guest