PDA

View Full Version : PFR Filter causes 3Bet Stat Error



ProsperousOne
05-10-2010, 06:36 PM
While doing a hand review with my coach, we discovered a bug in the 3Bet stat. When you select "PFR=TRUE" in the More Filters, the 3Bet% Stat goes to 100 percent for post postitios, (99.x in middle and c/o), resulting in an overall 3bet of 99.9%.

From the custom stats forum, the formula for 3Bet appears to be correct:

<Stat GroupName="Default" ColumnName="3Bet"
ValueExpressions="

sum(case when ph.preflopaction_id = 3 or
ph.preflopaction_id = 4
then 1 else 0 end) as CouldThreeBet;

sum(case when ph.FirstPreflopActionType_ID = 3 and
(
ph.preflopaction_id = 3 or
ph.preflopaction_id = 4
)
then 1 else 0 end) as DidThreeBet;"

Evaluate="DidThreeBet*100.0/CouldThreeBet"
ColumnHeader="3Bet%"
ColumnFormat="0.0"
ColumnWidth="61" />

I attached a screen shot for sanity. I've verified this behavior with a few different buddies, all have the same error. We're obv. not 3betting 100% when we're PFR, so something is amiss....

:confused:

morny
05-10-2010, 09:19 PM
Cheers for that, it appears it happens with several of the reports so i wrote up a bug with some screenshots and forwarded to the developers