Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by mrpiter » Wed Apr 24, 2013 2:17 pm
Hi guys,
I would like to create a report or a stat (not sure how this can be done) that would show me the average pot size on each limit. Ideally, when I view stats by stake I would like to have a column that would show me the average amount of money in a single pot. I believe the stat would be something like: total money in all pots / number of hands. Is there any way to do it?
-
mrpiter
-
- Posts: 7
- Joined: Sun Apr 26, 2009 8:36 am
by kraada » Wed Apr 24, 2013 5:06 pm
There's a graph for that - go to the Graphs page and choose Global Game Statistics and pick Pot Size. It should give you some good information which may well satisfy your needs.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by mrpiter » Thu Apr 25, 2013 3:14 pm
No, the graph is not precise. Is there any way to find out what is the average pot?
-
mrpiter
-
- Posts: 7
- Joined: Sun Apr 26, 2009 8:36 am
by kraada » Thu Apr 25, 2013 4:18 pm
Yes, to find out exactly what you would do is create a custom stat - you need one custom column for this on the Columns page. Call it amt_pot_size with definition sum(cash_hand_summary.amt_pot) - then create your stat with the defintion amt_pot_size / cnt_hands and you can add it to a report that is broken down by stake and you'll see the average pot size for each stake listed.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by mrpiter » Fri Apr 26, 2013 2:37 pm
I have tried that but it does not work. I have managed to create a column that you said:
[ img ]Unfortunately, I cannot create the stat because it gives me this error message:
[ img ]Any ideas?
-
mrpiter
-
- Posts: 7
- Joined: Sun Apr 26, 2009 8:36 am
by WhiteRider » Sat Apr 27, 2013 4:27 am
You need to create the column and the stat in the "Player" section (not the Hand) section since this stat is for all of a players hands, not individual hands.
Click the green question mark icon in that window to watch the short video tutorial and check out the
Custom Statistics Guide for more information on working with custom stats.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: Opperwezen and 0 guests