A filter to filter out high vp persons

[Tuxadel]

Im interessed in seing all the pots I have been in where it has been a raise preflop, and the person im playing against has more than 35vp. Is this possible to do? I have searched the filters, and I have also looked for a topic about it on this forum but I cant seem to find any. I also have 400k hands, so I guess there will be tons of pots, but im interessed in analyzing them :)

Thanks.

[kraada]

If you add the following in the blue Filters link of a custom report it will filter only for hands that included someone who has a VP$IP between X and Y who put money in the pot:


player.id_player in (SELECT player.id_player from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player and holdem_hand_player_statistics.flg_vpip GROUP BY player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN X AND Y)))

Replace X and Y with 35 and 100, then use the simple filters to filter for times you made the raise or otherwise did whatever you want to do and away you go :)

[eroock]

Doesn't seem to work for me. No results shown. It's Holdem Cash Hand right?

[WhiteRider]

It's showing all hands for me. I'm not sure what's wrong with the query, though - as far as I know kraada will be on later so we'll see if he can see the problem.

[kraada]

I'm definitely getting results - what did you put in for X and Y and how big is your database?

[WhiteRider]

I get results, but the problem is I get all hands, and I tried quite restrictive values - e.g. 70 - 100.

[kraada]

Oh, Holdem Cash Hand - I was looking in Player Statistics.

In HCH you need to swap it around to filter on hands not players :oops:

This should do it:

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player and holdem_hand_player_statistics.flg_vpip GROUP BY holdem_hand_player_statistics.id_hand, player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN X AND Y)))