Custom stats for summary report

[kondom91]

I would like to create a bunch of custom stats to add into my summary report by position with adj BB/100 filtered by effective stack size.
I.e.
Adj BB/100 at effective stack >= 0 AND effective stack < 5
Adj BB/100 at effective stack >= 5 AND effective stack < 10
Adj BB/100 at effective stack >= 10 AND effective stack < 15

and so on..

[kondom91]

So I tried creating two new columns:

amt_expected_bb_won__0_2

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_effective_stack >= 10 and tourney_hand_player_statistics.amt_p_effective_stack < 12, tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb, 0])

cnt_hands__eff_stack__0_2

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_effective_stack > 0 and tourney_hand_player_statistics.amt_p_effective_stack < 2, 1, 0])

And a new statistic with them called All-In Adj BB/100 0-2

Code: Select all

amt_expected_bb_won__0_2 / (cnt_hands__eff_stack__0_2bb / 100)

It is not working :D

[Flag_Hippo]

The effective stack sizes you are using in each column are not the same (10 & 12 vs 0 & 2) and if you want the effective stack sizes in big blinds you also need to divide the effective stack sizes in your columns by tourney_blinds.amt_bb.

[kondom91]

The effective stack sizes you are using in each column are not the same (10 & 12 vs 0 & 2) and if you want the effective stack sizes in big blinds you also need to divide the effective stack sizes in your columns by tourney_blinds.amt_bb.

Thank you! Yes, I was working on two different stack sizes.

I divided the effective stack sizes in the colums as you said and it is now working correctly.
Thank you very much for your help :heart:

[WhiteRider]

That's great to hear - thanks for the update!