Filtering hands where hero covers villain (for KO tourney)

[The Practitioner]

Hi there

I am trying to generate a report (ideally a quick filter would be handiest but I don't see that it is possible) to filter for hands that went all in/call at any point, specifically where hero's stack covers villain. (the purpose is for bounty tourneys, if it matters).

Any advice on this please as I have been struggling.

Thanks!

[Flag_Hippo]

Code: Select all

(tourney_hand_player_statistics.enum_allin SIMILAR TO '(P|F|T|R|p|f|t|r)' or tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|f|t|r)') and tourney_hand_player_statistics.flg_showdown and (tourney_hand_player_statistics.amt_bet_ttl < tourney_hand_player_statistics.amt_before)

You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

[The Practitioner]

Thank you! That seems perfect.