I am BB SB limp, How to filter that ?

[Emeric]

I would like to see all hands where I am BB , everybody folded and the SB limped.
I guess it is not that hard to do but I dont see how.

[WhiteRider]

No, I don't think this is possible yet with the 'standard' filters, but you could do it in a Custom Report by filtering on 'free look from BB' and being in position. Documentation.

You would have to create a new stat for being in position on the flop, e.g. using the database field:
holdem_hand_player_detail.flg_f_has_position

[scbrigad]

I don't see 'free look from BB' where is this located?

I did create custom variables "Att to Steal from SB = (cnt_steal_sb / cnt_steal_sb_opp) * 100" and "Gave Walk from SB = "(cnt_steal_sb_walk / cnt_steal_sb_opp) * 100"

where...

cnt_steal_sb = sum( if[holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_steal_att, 1, 0])

cnt_steal_sb_walk = sum( if[holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.flg_p_fold, 1, 0])

cnt_steal_sb_opp = sum( if[holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_steal_opp, 1, 0] )

so you could just subtract those two from 100% and you'd get the limp % (not considering limp-reraise or limp fold possibilities).

[WhiteRider]

I don't see 'free look from BB' where is this located?

This is one of the 'standard filters'. There may not be an actual stat defined for this yet, sorry.

[Emeric]

I am in the insert menu in the filter menu of the report menu. I have the documentation about the report.
Could you help me to create the filter " being in posision " ?

[WhiteRider]

You will need to create a stat for being in position on a street, there is a database field for this - I'm afraid I don't know exactly what it is off the top of my head and I don't have time to look it up now, if you can't find it, please bump this thread later. It's something like player/hand_detail.flg_f_has_postition, create a column for this, then a stat based on the column.

[Emeric]

Sorry, I don't find.
I think it will be easier after my first report will be done, but at the moment, I am lost.

[WhiteRider]

The database field is:
holdem_hand_player_detail.flg_f_has_position
..but someone has reported a problem with it, and we're currently investigating, so feel free to build your stats, but don't rely on it too much at the moment!

[Emeric]

So I made a report with the stat holdem_hand_player_detail.flg_f_has_position
nothing more, I am not a specialist and I hope I had nothing to had.
The idea is to filter all hands where I am in position

So I didn't had any if ( holdem_hand_player_detail.flg_f_has_position ) then ??? or whatever
I entered directly holdem_hand_player_detail.flg_f_has_position

So I am in the report menu, then I click on filter then I click on insert and I enter my stat and the problem is always the same, PT3 crashs when I try to save, with the following message.

Error: Access violation at Ox7C91E8C5 (tried to write to 0x00040FF8 ), program terminated.

[WhiteRider]

Did you create a Column to access the database field, then create a Statistic from that?
Did you set the 'format' of the Stat, and column width, etc?

What happens if you add your new Stat to your report, rather than filtering on it?