Report Idea AVG Potsize made hand x

[js2002]

Hi,

just had a idea.

f.e. I want to know the avg potsize of a set+ typ hand or a TPTK typ hand for a limit.
How do I begin? Which section? sessions I guess and then?
possible report?

[kraada]

I'd probably start by making an average pot size stat and then filter by made hand values and run a bunch of reports.

[js2002]

Hmmm, I want a single report. Not possible huh?

I even wont start building it, Its too complex for me. I hope a user here wants to build it.

[WhiteRider]

You could add the "Final Hand" stat to your report to split it into rows for each final hand.
Bear in mind that this shows the hand that you would have made even if you folded, so depending on exactly what you want to see you may want to build a variation on it where you check for which street you see.

[js2002]

You could add the "Final Hand" stat to your report to split it into rows for each final hand.

How? How do I split it into rows?

Bear in mind that this shows the hand that you would have made even if you folded, so depending on exactly what you want to see you may want to build a variation on it where you check for which street you see.

I dont want to "filter on active player" I want a general limit report that answers my "questions" above, f.e.

How much is the avg pot when u hold top pair top kicker at NL2. answer fe : 36BB

...so I want all TPTK hands that went to SD and won and even the losses because the have to be decreased

[kraada]

Any column that is used that has the Group By box checked breaks a report down into rows, with one row for each unique value in the column.

For example if you did something like this in a column:

if[not(holdem_hand_player_statistics.flg_f_bet), 0, if[holdem_hand_player_detail.val_f_bet_made_pct <= 100, 1, 2]]

and had that Group By, and used it in a stat, you'd end up with three rows - one where you did not bet the flop, one where you bet the flop the size of the pot or less, and then a row for all other hands (which by elimination ends up being all flop overbets).

You can do similar things with the holdem_hand_player_combinations table if you want, though there is already a Final Hands stat which breaks things down into broad categories (e.g. One Pair) - if you want to fine tune it further, you'll need to build this kind of stat.

[js2002]

Wow didnt know all these things, thx.

I wont have time to build it, maybe I start it when I grind again and have more sample.

ps

Tutorial video 3 will be released next week!
its in german and maybe not reachable for US people :(
pokerstrategy.com is forbidden for u huh?!

[kraada]

I can get to their main website fine, but I don't personally have an account (nor do I speak any German).

[js2002]

I took some thoughs:

where do I have have to build the avg pot column? section sessions? oder hand (so details)?

then I can use the combinations.foru aof a kind etc AND flg SD etc...

[kraada]

If you're going to use data about individual hands it needs to be in the hands or player statistics sections. Just if you use the combinations table, don't use it in a HUD stat - it'll slow the HUD way down.