Non-bluffer stat

[Jackntigger]

Hi,
I'm having trouble writing a hud stat expression for the instance where the player's last action was to check and he lost to a high card hand at showdown. How do I create an expression that shows that the winning hand's final strength was high card?
Obviously, the player would have high card too but I want to show where the player neglected to bet and was beat by a final strength on river of high card.
I hope this makes sense. I'm trying to create a stat where a player declines to bluff and where we don't need to know what the player was holding, just that he didn't bet and was beat by a high card hand.

I've tried:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player r where chps.id_player = r.id_player and lookup_hand_ranks.id_hand_rank = 9)

Although this validates, it's not doing what I was hoping

[Flag_Hippo]

Is that all you have? You've only included an expression with a subquery here that's using no SUM IF or CASE WHEN statement or anything that specifies the hand from the perspective of the player you are writing the stat for.

With regards to the subquery for the other player you'd want to test for them having high card and winning the hand which would look like this:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_hand_player_combinations chpc where chps.id_player = chpc.id_player and chps.id_hand = chpc.id_hand and chps.flg_won_hand and chpc.flg_r_highcard)

Also how are you counting the statistic? Is it just a raw count of times using a single column or are you trying to calculate a percentage? If a percentage then include full details of both custom columns along with a written definition.