Hello,
I was trying to build this stat but i am not sure if I am doing it right...
Bet River stat is configured like this:
(cnt_r_bet / (cnt_r_bet + cnt_r_check)) * 100
Where:
cnt_r_bet:
sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])
cnt_r_check:
sum(if[cash_hand_player_statistics.flg_r_check, 1, 0])
----
Bet River (Vs Hero) could be configured like this:(cnt_r_bet_vs_hero / (cnt_r_bet_vs_hero + cnt_r_check_vs_hero)) * 100
Where:
cnt_r_bet_vs_hero:
sum(if[cash_hand_player_statistics.flg_r_bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and ((hero.flg_r_open_opp and hero.flg_r_check) or (hero.flg_r_has_position and not hero.flg_r_open_opp))), 1, 0]) ??
cnt_r_check_vs_hero: ??
...
If the Villain is betting in river, I have to define in the subset Heros actions in this river? Maybe It could be enough to say that hero is facing a bet in river but no idea about how to do it...
Can someone help me on this please?
Thank you!