Check-call ratio

[BoFo]

Hi!

I try and I try...Programming does not come easy to me.

My last try was to build a stat to show me their check-call ratio.

I thought I’d need a column to show the numbers for having checked and called, multiply by 100 and divide by the number for having checked (cnt_f_check).

To keep it simple I looked into the existing columns and found:
Cnt_f_check_raise_opp:
sum(if[holdem_hand_player_statistics.flg_f_check AND (holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_ call > 0 OR holdem_hand_player_statistics.cnt_f_ fold), 1, 0])

I thought: If this works, it must be possible to reduce it to something that also works. So I cut out: (the OR raise, the OR fold) - parts:

sum(if[holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.cnt_f_call > 0, 1, 0])
Tried validate, OK. Grouped by: sum, named it: cnt_f_check_call

Made a stat:
(cnt_f_check_call / cnt_f_check) * 100, Format: /%.2f. Validation OK.

Applied it to the “Player stats” – HUD.

Opened a game, but now the HUD wont show. Even though the “Table” – HUD works.

??? – Bo.

[WhiteRider]

OK, well that stat looks reasonable.
If you remove it from the HUD again, does the HUD work again?
Try adding your stat to a report, like the Known Hands report; see if that works.

[BoFo]

Yes, if I remove it, the HUD's OK. I'll try to make a report, never done that before. - Bo

[WhiteRider]

You don't need to make a new Report, just click the little spanner/wrench icon to the right of the known starting hands report.

[BoFo]

It says:

ERROR: aggregates not allowed in GROUP BY clause.

I checked the group by sum, because I had trouble last week because I didn't.

[BoFo]

Up and running! Thanks ever so much!!

[WhiteRider]

Great! Is it working on the HUD now too?

[BoFo]

Yep! Unchecked the GROUP BY!