Stat issue?

[Waingro13]

Hello,
AKo shows a Winning % of 79% while all AKo hands have won chips. Anything I missed?

Sans titre.jpeg

(188.74 KiB) Downloaded 940 times

[Flag_Hippo]

The column used for that statistic only has the data from winning hands so that's all you will see there.

[Waingro13]

The column used for that statistic only has the data from winning hands so that's all you will see there.

Hmmm not sure I have understood well.
The definition of Win % is: cnt_won_hands / cnt_hands
What do you mean by "column"? cnt_won_hands and cnt_hands are both columns but I suspect you mean the area in which hands are detailed right?
This would mean that the informtion in the heat map is not strongly related to those in the hands list, only the won hands being detailed.

[Flag_Hippo]

Specifically the data for the hand listing comes from the numerator column (the first one):

(Numerator / Denominator) * 100

For example if you select 'Preflop 3Bet %' as the heat map statistic you will see hands that you 3Bet (not the hands where you had the opportunity to 3Bet):

(cnt_p_3bet / cnt_p_3bet_opp) * 100

If you select 'WTSD' as the heat map statistic you will see the hands where you reached showdown (not all hands where you saw the flop):

(cnt_wtsd / cnt_f_saw) * 100

If you use 'Win %' as the heat map statistic you will only see hands that were won (not all hands):

(cnt_won_hand / cnt_hands) * 100

because the cnt_won_hand column only has data from winning hands:

cnt_won_hand

Code: Select all

sum(if[cash_hand_player_statistics.flg_won_hand, 1, 0])

If you want to see all hands, winning hands & losing hands (excluding hands with no net win/loss), or some other result in the hand listing you can create a custom statistic and format that as you see fit - see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough.

[Waingro13]

Thx for explainations, although most of them were ok for me but my question was why only winning hands were listed.
But I understood the reason, and it appears fair.
So what I would need is a custom stat showing the percentage of won hands following a PF 3bet but with a listing with all hands corresponding to PF 3bet, including hands that have lead to a loss.
Because not surprinsingly I am interested in why some of my 3bets did not work as expected.