Custom stat problem with summary row

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Custom stat problem with summary row

Postby ethanrox » Thu Oct 11, 2018 2:25 am

I am creating two custom stats - EV SD BB/100 and non-SD BB/100 based on the 4-stat pack by WhiteRider.

The problem I am having is that when using the Statistics/Group by Position(Full Ring) Report,
they show correctly by position, but incorrectly in the summary line.
Image

Both are off by a factor of 4 which I suspect is due to the size of the big blind - 0.25. or 1/4.

The definitions are as follows:
sD EV: ((amt_expected_won-amt_won_no_sd) / amt_bb) / (cnt_hands / 100)
non-SD: (amt_won_no_sd / amt_bb)/(cnt_hands / 100)

Can it be that amt_bb is somehow Game Currency stat and the Summary row is only for My Currency?
ethanrox
 
Posts: 66
Joined: Mon Sep 03, 2012 7:14 pm

Re: Custom stat problem with summary row

Postby Flag_Hippo » Thu Oct 11, 2018 5:32 am

Please attach your stats here or in a Support Ticket and we'll take a look.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Custom stat problem with summary row

Postby ethanrox » Thu Oct 11, 2018 6:25 am

Flag_Hippo wrote:Please attach your stats here or in a Support Ticket and we'll take a look.


Thanks, opened a ticket.
ethanrox
 
Posts: 66
Joined: Mon Sep 03, 2012 7:14 pm

Re: Custom stat problem with summary row

Postby WhiteRider » Fri Oct 12, 2018 2:22 am

If you have hands with different BB sizes then that type of expression won't work. amt_bb does not have a single value across multiple hands, so you will need to set up your expressions in columns (instead of the stats) where you can do your calculations on a hand by hand basis to divide by the relevant BB size for each hand.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom stat problem with summary row

Postby ethanrox » Fri Oct 12, 2018 8:53 pm

I am not sure I understand. The expression works fine by position. So it "works" somewhat. I don't see why it doesn't in the summary row.
ethanrox
 
Posts: 66
Joined: Mon Sep 03, 2012 7:14 pm

Re: Custom stat problem with summary row

Postby WhiteRider » Mon Oct 15, 2018 2:30 am

Take a look at how a built-in stat like "All-in Equity Adjusted BB/100" is made.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom stat problem with summary row

Postby ethanrox » Tue Oct 16, 2018 5:04 am

Ok. I managed to accomplish what I wanted with help from support:

1. SD Stat needed an extra custom column with definition amt_expected_bb_won_sd:

sum(if[ cash_hand_player_statistics.flg_showdown, cash_hand_player_statistics.amt_expected_won / cash_limit.amt_bb, 0 ])

Then the stat's definition is simply:
amt_expected_bb_won_sd / (cnt_hands / 100)

2. NoSD Stat extra custom column amt_bb_won_nosd:
sum(if[ cash_hand_player_statistics.flg_showdown, 0,cash_hand_player_statistics.amt_won / cash_limit.amt_bb])

Stat definition using the column:
amt_bb_won_nosd / (cnt_hands / 100)
ethanrox
 
Posts: 66
Joined: Mon Sep 03, 2012 7:14 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 32 guests

cron