Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by Tinman9956 » Sat Oct 07, 2017 2:45 pm
Is it possible to make this stat for a hands report. Thanks
- Attachments
-
-
Tinman9956
-
- Posts: 222
- Joined: Wed Nov 02, 2011 8:29 pm
by potamito » Sat Oct 07, 2017 3:17 pm
Do you wanna create a filter to isolate the the hands with X% of Avg Allin Equity?
-
potamito
-
- Posts: 802
- Joined: Wed Apr 21, 2010 4:20 pm
by Tinman9956 » Sat Oct 07, 2017 4:44 pm
I created a few race reports 0-20% 20%-45% etc and I have the all in equity stat in the reports, but I would like to know my average for each report. The stat in my screm shot does what I need to see, but can only be used as a player stat. Thanks .
-
Tinman9956
-
- Posts: 222
- Joined: Wed Nov 02, 2011 8:29 pm
by WhiteRider » Mon Oct 09, 2017 3:40 am
You could display the average equity in the summary line, but the simple version would be the average across all hands (including those with zero equity when you weren't all-in). If your report is only including all-in hands then this may be what you need.
If you want to do that I think the simplest thing to do would be to make a copy of the existing 'val_allin_equity' Hand column and change the Summary Type to Average in your copy. Then make a copy of the Hand stat 'All-In Equity' and use your new column, and change the stat's Summary Type to 'Number'.
If your reports include non-allin hands then you'll need to make a new column to count the all-in hands and change the summary expression to divide the total equity by the number of all-in hands.
-
WhiteRider
- Moderator
-
- Posts: 53987
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by Tinman9956 » Mon Oct 09, 2017 1:00 pm
Thanks you, you first suggestion is what I needed .Just one more thing ,how do I get it to show the % for the total. Thanks
- Attachments
-
- % sign.PNG (825 Bytes) Viewed 1117 times
-
Tinman9956
-
- Posts: 222
- Joined: Wed Nov 02, 2011 8:29 pm
by Flag_Hippo » Mon Oct 09, 2017 6:32 pm
The average should not be 4797 for this stat so did you change the summary types for the new column and the new stat as WhiteRider suggested? Also if you want the % symbol you will can edit the summary expression to this:
- Code: Select all
format('{1}%', format_number(your_column_name * 100.0, 2, false, false))
- Attachments
-
- avg.PNG (2.79 KiB) Viewed 1110 times
-
Flag_Hippo
- Moderator
-
- Posts: 14512
- Joined: Tue Jan 31, 2012 7:50 am
-
Tinman9956
-
- Posts: 222
- Joined: Wed Nov 02, 2011 8:29 pm
by Flag_Hippo » Tue Oct 10, 2017 5:57 am
Your duplicated statistic is using the original column (val_allin_equity) so you need to change that to the new column (val_allin_equity_copy).
-
Flag_Hippo
- Moderator
-
- Posts: 14512
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 20 guests