Creating new stat?

[redhot0007]

FWIW I'd suggest removing the position check from your columns and use the Hud Position property instead - that will save you a significant amount of work as you'd only need to build one stat per stack size rather than 6.

OK i just moved the position check from columns like this and filtered by positions in hud profile

formula(hands raised / hands) * 100

RFI
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND
(tourney_hand_player_statistics.flg_p_open_opp) AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])


Hands Played
sum(if[tourney_hand_player_statistics.id_hand > 0 AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])

But the numbers in the mid and late positions are way to small i will upload the picture of the HUD what i am seeing. Like in the SB it should be like 60%????

Thanks

[kraada]

When you hover over the stat what do you see as the times and opportunities listed?

[redhot0007]

When you hover over the stat what do you see as the times and opportunities listed?

i made a shot for you when i hover over the stat. it is a reg and i have large sample on him and the i see that he is raised 6 times out of 71 which is unreal

Thanks

[kraada]

Choose that guy as the active player in PT4 and use the filters to filter to hands where he was in the SB and folded to with that stack size - if it's only 71 hands it shouldn't take long to verify if this is accurate or not.

The filters you want for this test are:

Hand Details -> Player Position -> Preflop -> Active Player Exactly 9
and
Actions and Opportunities -> Preflop -> Opportunities -> Opportunity to Open the Pot (or Steal Opportunity, both would do the same thing here)
and
Hand Details -> Pot Size & Stack Depth -> Preflop -> Effective Stack between 9 and 11 big blinds

[redhot0007]

Choose that guy as the active player in PT4 and use the filters to filter to hands where he was in the SB and folded to with that stack size - if it's only 71 hands it shouldn't take long to verify if this is accurate or not.

The filters you want for this test are:

Hand Details -> Player Position -> Preflop -> Active Player Exactly 9
and
Actions and Opportunities -> Preflop -> Opportunities -> Opportunity to Open the Pot (or Steal Opportunity, both would do the same thing here)
and
Hand Details -> Pot Size & Stack Depth -> Preflop -> Effective Stack between 9 and 11 big blinds

Did exactly what you told me it shows me those six hands and few other hands that he folded but not 71 hands that he had the opportunity

[kraada]

How many total hands match that filter for him?

[redhot0007]

How many total hands match that filter for him?

It filtered 11 hands

[WhiteRider]

Your opportunities column doesn't appear to be checking for an open opportunity, so it is counting all hands the player was in the SB rather than just those where he had an opportunity to RFI.
Try including "tourney_hand_player_statistics.flg_p_open_opp" in the "hands played" column too.

[redhot0007]

Now its working so thanks very much...