Page 1 of 1

HUD not showing expected values

PostPosted: Wed Nov 01, 2017 7:15 pm
by freesko
Hi,
I'm building some stats and they seems to work but when I add them to my hud, their times/opportunities doesn't match with expected ones.
Here is an example:
Stat: BB calls an SB open in a 3+ players dealt hand, the pot goes HU, and then fold to a flop CBet.
Expression:
(opportunities)
sum(if[cash_hand_player_statistics.position=8
AND cash_hand_summary.cnt_players > 2
AND cash_hand_summary.cnt_players_f = 2
AND lookup_actions_p.action='C'
AND cash_hand_player_statistics.val_f_bet_aggressor_pos=9
AND cash_hand_player_statistics.flg_f_cbet_def_opp , 1, 0])

(times expression is the same but adding lookup_actions_f.action='F')

I made a Hand Report to check if it is working correctly, and all the hand replays match with the expressions.

Captura de pantalla 2017-11-01 a las 23.55.14.png


Then, I add the stat to my HUD without filtering it expecting to see (3/9) (times/opportunities) as in the Hand Report but it's shown (4/23).
(If I filter the stat by Position = BB somehow it shows (4/9))

Don't know if it's related but in Reports and Graphs the amount of hands computed are exactly the half than in "cnt_hands", the amount I see in HUD.

What am I missing?

Thanks in advance.

Re: HUD not showing expected values

PostPosted: Thu Nov 02, 2017 8:22 am
by Flag_Hippo
The times/opportunities are working fine for me in the HUD and match the results in my own hand report. Have you rebuilt your custom cache after adding these new stats? If not go to 'Database > Database Management', select 'Rebuild Cache > Custom Cache Rebuild' and see if that resolves the problem.

Re: HUD not showing expected values

PostPosted: Fri Nov 03, 2017 7:59 am
by freesko
Yeah it worked!
Anyway the "Hands Abbreviated" stat is still doubled. Any idea of what can be causing it?

Thanks for your help!

Re: HUD not showing expected values

PostPosted: Fri Nov 03, 2017 8:54 am
by Flag_Hippo
Can you please give me some more details on this 'Hands Abbreviated' issue.

Re: HUD not showing expected values

PostPosted: Fri Nov 03, 2017 2:15 pm
by freesko
Let's say I choose a random player from my database. I run either all games/all dates results or graph and the are 750 hands tracked.
Then I open a replay from this player (without filtering stats from last x days or whatever) and the stat "Hands Abbreviated" which is basically the built in column "cnt_hands" shows 1.5k hands, exactly the double of hands I have tracked for each player. I have not modified that built in stat...

Re: HUD not showing expected values

PostPosted: Fri Nov 03, 2017 4:15 pm
by Flag_Hippo
Thanks. Is your HUD reading from more than one database? You can check this via 'HUD -> Edit HUD Options -> General Settings -> Advanced'.

highfalutin