flopped sets report

[pg1111]

Hi.
I downloaded flopped sets report and over 50k hands it says i flop set 1 in 16 times on average.is this report working fine or am i just running so bad?
Thanx:)

[kraada]

I honestly haven't looked at it personally so I can't say for certain but I'll try and take a look in a bit for you.

[doco]

Mine is 1:11.1

[kraada]

It looks like that report isn't filtering for times you actually saw the flop - since there are going to be times you get pocket pairs and don't see a flop, obviously the number of times you flop a set is going to be low.

Add the filter:
holdem_hand_player_statistics.flg_f_saw

to the Filters area and that should filter to times you actually saw flops and thus give you a more accurate idea of how often you were hitting sets (you can't hit a set if you don't see the flop!).

I'll make alonalbert aware of this thread.

[doco]

Are we just adding flg_f_saw = true to the filter area. Doing so returns a very long SQL string in error.

holdem_hand_player_statistics.flg_f_saw must appear in the group by clause or be used in the aggregate function...

EDIT:
Ok, I think I got it. I misunderstood WHERE to add the filter. Check the saw flop check box under the Filters | Misc. Not the [ Filters ] link in the report browser.

Old Ratio 1:11.1 ---> New Ratio 1:9

[kraada]

And it should be 1 in 8.5 so you're pretty close now :)