My report - help to create report

[Kalledrengen]

Info on gametype:
- Heads up no limit cash

I'd like to be able to see my own stats vs a specific opponent tendency. Like what my stats (call%, 4b%, fold to cb% etc) looks like someone who say 3-bets 25% or someone who c-bets 90%+. My thought was to create a new report in "my report" and have it show only players who 3-bet 25% or more. Then I could somehow add all these players to an alias and somehow show my stats vs that alias alone. But can't seem to figure out how to do any of this.

So is it possible for me to see my stats vs a specific 3b% and/or a specific cb%?

This will be useful for me so I can see if I defend enough hands when people 3-bet me a lot.

I've tried looking through your tutorials and searching for reports in the forum but so far I've come up empty so would appreciate any help.

[WhiteRider]

That kind of thing is pretty tricky as you'd need to filter both an opponent's overall stats and for individual hands. I'm not sure whether it's possible, but Kraada has built more custom report filters than me and may have some ideas when he returns (I believe he's off today because of ThanksGiving in the US).

[kraada]

This is possible but the report results are going to take an awful long time.

To filter for all and only hands where someone who has a 3bet between 25 and 100 use this Filter Expression:

EDIT: This is not the correct expression - please use the expression from a couple of posts down.

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

Then you can use a simple filter to look at times you also faced a 3bet and that should get you what you want. Expect a report with this filter to take several minutes or longer to show you data (if your database is large it could take up to an hour or more).

[Kalledrengen]

Hey,

Thanks for the filter. My database is only like 150k hands tops I think so it was almost instant for me actually. Though I can't seem to figure out how to actually get something out of this.

I went into "My reports" and clicked "filter" --> "add new expression filters" --> copy/pasted the code. When I pressed save it gave me an error but when I clicked ok it accepted it and the report now shows:
Villain name - Won - hands - all-in adj bb/100

The number of hands listed by each villain is only like 10-50 hands so it does seem like it have filtered for hands they 3b. (like when I filter for hands where I had the opportunity to 4b it doesn't reduce the amount of hands).

Anyway a few problems I hope you can help me with.

- I have no place to replay the hands. It just shows the amount of hands they 3b vs me but I can't actually click them and see them in a replayer.
- I'd like, if possible, to see my stats vs them (all togther, and also individually if possible). What I'm interested in knowing is how often I fold to 3b when facing someone who 3b 25%+. And how much I'm folding to c-bets (and how often I'm facing one) when people 3b me 25%+.

My only thought right now is to go through the list of villains and create them all as an alias. Though it's bit of a longer process added them all to an alias if I have like 50+ villains.

Thanks again.

[kraada]

If you want to see individual hands you need to create a Hand report not a Player report.

This filter will validate and work properly (I'd been looking at the PT3 forums too much lately apparently):

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

[Kalledrengen]

Thanks I think I've gotten it working now by making hand report and player report it seems I can find the information I want.

Btw when I make a "player report" it will show my name twice (cause I have added an alias). This is mildly annoying cause this means below each column name (fold to cb, raise cb etc) two numbers will be displayed and if I want the "total/average" I have to look at the bottom of the screen (and the column name is in the top of the screen). Unlike say the "statics" tab I do not have the option to "scroll" the "total/average" stats up closer to the top of the screen.

I'm guessing there is not solution to this?

[Kalledrengen]

Damn I was sure I had it working before. But now when I try to filter for "4b opportunities true" it just won't show any hands. If I filter for "flop raise cb oppotunity" it will correctly show those hands. This is true both when I make a player report and a hand report. How can this be?

[kraada]

Is it possible you don't have a 4bet opportunity against those players? Those aren't that common.

[Kalledrengen]

It's heads up so if I'm filtering for players who 3-bet me 25%+ I should have a lot of opportunities to 4-bet them

[kraada]

That actually does depend - you don't have an opportunity to 4bet them if they're already all-in - I presume you're deep enough regularly that this isn't the case though?