Page 1 of 3

database analysis

PostPosted: Tue May 15, 2012 10:47 am
by 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 ...

Re: database analysis

PostPosted: Tue May 15, 2012 12:18 pm
by 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.

Re: database analysis

PostPosted: Wed May 16, 2012 9:15 pm
by 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

Re: database analysis

PostPosted: Thu May 17, 2012 3:42 am
by 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.

Re: database analysis

PostPosted: Sat May 19, 2012 1:12 am
by 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.

Re: database analysis

PostPosted: Sat May 19, 2012 5:15 am
by WhiteRider
I would expect to see only the percentage in the summary line - what stat(s) are you looking at?

Re: database analysis

PostPosted: Sat May 19, 2012 9:41 pm
by SarahSugar
3bet vs button, PFR from ep , PFR etc

Re: database analysis

PostPosted: Sun May 20, 2012 5:38 am
by 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?

2012-05-20 10h32_27.png

Re: database analysis

PostPosted: Sun May 20, 2012 9:05 am
by SarahSugar

Re: database analysis

PostPosted: Sun May 20, 2012 9:07 am
by 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 :)