Square root

[kraada]

I think I get the idea, though I admit the last time I took statistics was . . . a long time ago.

Either way, what I'd try doing is going into the Expected PP Hit Flop stat and on the Format tab of the stat editor, you can edit the summary expression there. I believe if you explicitly put something to the effect of "2 * 0.322 * cnt_holecard_sqrt" there it should do what you want. I honestly haven't spent too much time working with the summary expressions, though, so you may have to fiddle to get it exactly right? Either way, do keep us posted and let us know if you get it working.

[Dan_Jazz_Man]

Either way, what I'd try doing is going into the Expected PP Hit Flop stat and on the Format tab of the stat editor, you can edit the summary expression there. I believe if you explicitly put something to the effect of "2 * 0.322 * cnt_holecard_sqrt" there it should do what you want

That's where I'm trying to do it. Again, cnt_holecard_sqrt is defined as sqrt(cnt_holecard), but there's no way to calculate sqrt(cnt_holecard (all pairs)) in the summary expression - what we get is sqrt(cnt_holecard(AA)) + sqrt(cnt_holecard(KK)) ... + sqrt(cnt_holecard(22)), since the cnt_holecard_sqrt column has the summary type "sum". And, of course, sqrt(A+B+ ... +N) is not equal to sqrt(A)+sqrt(B)+ ... +sqrt(N).

[kraada]

I'm not sure if you can do it, but if you can access the lookup_hole_cards flags there, lookup_hole_cards.flg_pair is true for all hands that are pairs.

So what about something like sqrt(sum(if(lookup_hole_cards.flg_pair, cnt_holecards, 0)))? That should (I think?) give the square root of the sum of the number of times you had a pair. You can then multiply by whatever else you need.

[Dan_Jazz_Man]

I'm not sure if you can do it, but if you can access the lookup_hole_cards flags there, lookup_hole_cards.flg_pair is true for all hands that are pairs.

So what about something like sqrt(sum(if(lookup_hole_cards.flg_pair, cnt_holecards, 0)))? That should (I think?) give the square root of the sum of the number of times you had a pair. You can then multiply by whatever else you need.

It's already filtered down to pocket pairs in the report configuration, so it's the same as writing sqrt(sum(cnt_holecard)), which is "not a valid SQL"
I think I'm going to PM you with the report, I can't figure it out by myself, I'm about to lose my mind already.

[Dan_Jazz_Man]

Oh, .pt3rpt and .zip are not allowed in PMs, and I have no idea how to attach a file to a post here

[kraada]

I've sent you a PM on how to get the files to me.