cbet success against different player types

[dispatch3d]

I'd like to see what my cbet success rate is against different player types. I already added the stat that was in the repository, and did according to board texture. I looked through the reports to filter according to vpip and pfr. Apparently I can filter out different vpips (so I could, for example, see the cbet successes of all tags). However, I'd like to know what my cbet success is against ONLY tags. Would I have to mess with the actual database to get rid of the fish? Or is there a way to do this currently in pt3?

fyi I read the custom reports tutorial but prehaps i missed information in there that told me how to do this.

Thanks

dispatch3d

[kraada]

It's complicated but doable.

Thankfully, I've already done it so I can just paste those for you. You won't be able to use these filters with the simple filters though.

Add this filter to filter by VP$IP:

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 WHERE holdem_hand_player_statistics.flg_f_saw 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)))

Change X and Y to match whatever VP$IP range you want. Then you will only see hands that include at least one player that have a VP$IP that matches your specifications. Then just filter to active player, and run your report.

[dispatch3d]

I tried entering that expression into the filters under the report tab. Unfortunately it wouldn't validate the expression. I changed x and y to 10 and 25 fwiw. I was just going to use the included "fish list sample" under hold em cash player statistics initially before adding cbet success. I made sure it filtered active player, and took off the existing filters for that report. I made no reference to vpip directly in that filter. I'm not sure what you mean by "Add this filter to filter by VP$IP:". I assume the filter as copy and pasted will filter by vpip? And the filter is added under the reports tab.....

Really appreciate the help,
dispatch3d

[kraada]

Sorry, that's my fault. Use this instead:

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_f_saw GROUP BY holdem_hand_player_statistics.id_hand 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)))

I mean "add this filter in order to filter by VP$IP".