database analysis

[SarahSugar]

How do I analyse averages from my database?

Say NL100 SH , minimum 1000 hands on a player, what is the average 3bet value
What is the average cold call on button % range ...

[kraada]

The best way to do this kind of analysis is on the My Reports tab. Create a custom Player report grouping by Player and then you can add more stats to the list and see their values. In the blue Filters area you can filter on statistics so that you can narrow down the list.

For example, in the above setup you can add #Hands# > 1000 to only get data for your report from players with 1000 or more hands.

You can see overall averages in the very bottom of the report.

[SarahSugar]

Thanks, I tried All Players report,
but I didn't find how to add values like 3bet or openraise from UTG etc.
Just values like: 3bet size

Thanks

[WhiteRider]

You should be able to add any stat to the report - you can either type in the search field or browse by section. Double click to add stats to the report, and change the order with the up/down buttons.

[SarahSugar]

Thanks found it.
Good is the totals display on the bottom.
Id prefer to have the % only though and than hover over the totals out of numbers. it;s hard to read the way it is atm.

[WhiteRider]

I would expect to see only the percentage in the summary line - what stat(s) are you looking at?

[SarahSugar]

3bet vs button, PFR from ep , PFR etc

[WhiteRider]

I see the percentages for those stats, although I'm not sure what you mean by "PFR from ep" - is that a custom stat? The format of a custom stat needs to match the same pattern as the built-in stats in order to work in the same way.
Can you explain what you see instead, or post a screenshot?

[SarahSugar]

http://s14.directupload.net/file/d/2896 ... 4o_jpg.htm

[SarahSugar]

so yeah just some stats, but not only custom ones right?
even if, it would still be good to get the custom ones into a viewable format