[HOW TO] Create a filter to show me W$ w/ stack size ?

[Costel]

How to crate a filter for MTT & SNG to display hands where villain had a bigger stack and hero the lower one and both went all-in preflop and hero hand had a grater Equity against villain hand but finally did NOT win the pot ?

Thank you !

[Costel]

BUMP

[kraada]

Use this filter expression on the My Reports page:

tourney_hand_player_statistics.enum_face_allin = 'P' and tourney_hand_summary.cnt_players_f = 2 and tourney_hand_player_statistics.val_equity > .5 and not(tourney_hand_player_statistics.flg_won_hand)

[Costel]

Use this filter expression on the My Reports page:

tourney_hand_player_statistics.enum_face_allin = 'P' and tourney_hand_summary.cnt_players_f = 2 and tourney_hand_player_statistics.val_equity > .5 and not(tourney_hand_player_statistics.flg_won_hand)

Where did you get these variables from ?
I was looking for them here and none is there:

[kraada]

They're various pieces of columns joined together.