highlight the position where the player is

[majonyjony]

Hello, I'm working to improve my hud
I'm doing a statistics position pop up

Like this:
....................EP MP LP ETC
VPIP...............8..11..14..x
PFR................3..5 ...8...x
ETC
To facilitate the reading of the statistics, I want to highlight the position where the player is.

He made this statistic: (then change the text MP, BB, etc. for this statistic)

columns:

Indicadorposicion_button= sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=9, 1, 0])

Indicadorposicion_bb= sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=7, 1, 0])

Etc...

Variables:

var_posicion_button = Indicadorposicion_button
var_pos_bb = Indicadorposicion_bb

Etc..

Statistic:

if (var_pos_button = 1, 'BU',
if (var_pos_sb = 1, 'SB',
if (var_pos_bb = 1, 'BB',
if (var_pos_EP = 1, 'EP',
if (var_pos_MP = 1, 'MP',
if (var_pos_Hijack = 1, 'HJ',
if (var_pos_CO = 1, 'CO','_')))))))

Only works well for HJ, CO, BU, and SB.

I do not understand why this happens.

TY

[majonyjony]

column for MP =

sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=4 and tourney_holdem_hand_player_statistics.position=3 and tourney_holdem_hand_player_statistics.position=2, 1, 0])

?????

[kraada]

This sort of workaround will no longer function properly due to changes in the PT3 caching mechanism I'm afraid. I've requested that we add position as a live stat, but it may be a little while before it's available.

[majonyjony]

TY kraada!!

I hope to have it soon

[majonyjony]

Hi!, maibe works fine whith (new?) column "_cache_position_type"?

[WhiteRider]

That will not refer to the current position of the player - the cache is totals over all hands, split by position the hands were played, but it does not reflect the current position. We do not know that because we do not have information about the current hand.