Let's say I use a stat with this Value Expression:

(cnt_p_raise_first_in_pos1 / cnt_p_open_opp_pos1) * 100

And Format Type: Percent

The result ends up showing a numeric value. For example, 50.

But if I change the Format Type to Expression, is there any expression I could use to show the result as a bar?

If the result of the stat is still 50, I want to see a "half" bar.

I'm no SQL expert in any way, but maybe if I use expressions like SELECT and REPLICATE? Not really sure how they work.

Statistics: Posted by IA06 — Thu Oct 06, 2022 12:36 pm

]]>

Flag_Hippo wrote:

You have used 'oop' in your column name but 'opp' in the statistics value expression.

kaisefranz8 wrote:cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

You have used 'oop' in your column name but 'opp' in the statistics value expression.

sorry for the mistake. thank you

Statistics: Posted by kaisefranz8 — Sat Oct 01, 2022 10:01 am

]]>

kaisefranz8 wrote:

cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

You have used 'oop' in your column name but 'opp' in the statistics value expression.

Statistics: Posted by Flag_Hippo — Fri Sep 30, 2022 10:34 am

]]>

cnt_p_5bet_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (char_length(cash_hand_summary.str_aggressors_p) >= 4 AND substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int != cash_hand_player_statistics.position AND cash_hand_player_statistics.flg_p_4bet), 1, 0])

cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

Statistics: Posted by kaisefranz8 — Fri Sep 30, 2022 7:24 am

]]>

]]>

I was wondering how to work in percentage of effective stack when creating a custom column

would say

>= (tourney_hand_player_statistics.amt_p_effective_stack)*0.8

work for greater than or equal to 80% of effective stack?

If not how would express this idea in the code? that pt4 uses. I want to use this to create HUD stats.

Thanks!

Statistics: Posted by PFortune — Thu Sep 29, 2022 8:36 am

]]>

Statistics: Posted by Flag_Hippo — Wed Sep 28, 2022 6:40 am

]]>

kaisefranz8 wrote:

is it possible to have the statistic that includes the case where there is a cold 5bet without a 3bet first?

is it possible to have the statistic that includes the case where there is a cold 5bet without a 3bet first?

Yes that's possible.

kaisefranz8 wrote:

because the columns are valid, but when I go to enter the statistics even with spaces, it gives me the error, invalid expression

Please give specific details of your columns and value expression. Without those I cannot tell you what's wrong.

Statistics: Posted by Flag_Hippo — Wed Sep 28, 2022 6:39 am

]]>

But I still don’t understand the “hands” net ajusted graph. Why is it so much off from all ajusted winnings? Its 3 x higer than my C net ajusted winnings!

Statistics: Posted by Carlitone1 — Tue Sep 27, 2022 3:15 pm

]]>

]]>