Squeeze filtered

[Darvini]

Is there a way to filter squeeze on how many players got squeezed? And similarly a way to filter how many players got raised post flop.

[kraada]

I can't see an easy way to do that I'm afraid.

[Darvini]

Think there is a way to make a stat for it, but having some problems. I thought this would tell me the position of the third player to put money in on the flop: substring(cash_hand_summary.str_actors_f from 3 for 1)::int but I get error message when its in the column.

sum(if[ cash_hand_player_statistics.flg_f_first_raise and substring(cash_hand_summary.str_actors_f from 3 for 1)::int = cash_hand_player_statistics.position, 1, 0])

Why are there 4 different positions?

cash_hand_player_statistics.position
cash_hand_summary.cnt_players_lookup_position
lookup_positions.position
lookup_positions.absolute_position

[kraada]

You need to also make sure the string is 3 characters long - otherwise you end up with query errors (which is why this is rejected).

Adding in:
char_length(cash_hand_summary.str_actors_f) >= 3 should do the trick for you.

cash_hand_player_statistics.position is the position of the player from whose perspective you're making the stat and is almost certainly the one that you want to use.