Stat: How often do I face a bet after checking the turn?

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: Stat: How often do I face a bet after checking the turn?

Postby kraada » Mon May 04, 2009 12:56 pm

On the columns tab, click on the column and tell me what's in the box at the bottom (Sum, Count, Count Unique, Average, etc.)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Mon May 04, 2009 5:51 pm

kraada wrote:On the columns tab, click on the column and tell me what's in the box at the bottom (Sum, Count, Count Unique, Average, etc.)


Not sure I understand.

So here it is: I created two colums under the colums tab of the holdem cash player statistics section - cnt_bt_ri_after_ch_behind and cnt_ch_ri_after_ch_behind. Both of these are of the Summary Type Count. In the statistics tab, I've created the actual stat "Rbet on Tch" with the expression "cnt_bt_ri_after_ch_behind / (cnt_bt_ri_after_ch_behind + cnt_ch_ri_after_ch_behind) * 100".

There is no summary type for that stat - should there be one?

The expressions of the two colums are "sum(if[holdem_hand_player_statistics.flg_blind_b AND (holdem_hand_player_statistics.flg_f_cbet_def_opp) AND NOT (holdem_hand_player_statistics.flg_f_check_raise) AND (holdem_hand_player_statistics.flg_t_saw) AND (holdem_hand_player_detail.amt_t_bet_facing = 0) AND NOT**** (holdem_hand_player_statistics.flg_r_bet),1,0])"

*** or only AND


Edit: Nvm. It's supposed to be Summary Type Sum, right?
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby kraada » Mon May 04, 2009 6:01 pm

Yeah it should be summary type sum. Could you export these stats and attach them to a support ticket and reference this thread? Once we have the stats in hand we'll be able to figure out what's going on here more easily.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

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

Who is online

Users browsing this forum: No registered users and 4 guests

cron
highfalutin