Saw flop stat and float bet stat question

[Suboptimal88]

i created the first in success stat and saw flop in 3-bet pots , i made the value expressions after correctly i believe , they are validated , i think i may did a mistake with
the saw flop at 3-bet pot stat , i think it may saw now times i saw flop on preflop all ins etc...


this is the column: sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp) and cash_hand_player_statistics.flg_f_saw, 1, 0]) is it correct? pt4 validated it


also this is how i set the value expression for the first in raise success stat: (cnt_p_first_raise_success / cnt_p_first_raise) * 100

first raise success was the expression kraada gave me and first raise was an in built column , is it correct?


Lastly i dont know if i should create new column for *saw flop in non-3bet pots* i saw you put - instead

Would this value expression work? (cnt_f_saw - cnt_f_saw_3bet_pot) , cnt_f_saw_3bet_pot is my own column with the expression i wrote above.


Really sorry for bothering you more with questions , thats why im asking if there is a specific forum for this , im total noob with languages and programming

[WhiteRider]

this is the column: sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp) and cash_hand_player_statistics.flg_f_saw, 1, 0]) is it correct? pt4 validated it

This says that the player faced a 3Bet and saw the flop. If they make a 3Bet then it won't count that hand, so it depends exactly what you want to count.
I think you probably want to count any hand which was 3Bet or higher preflop?
In that case the best way to do that is with:

sum(if[ char_length(cash_hand_summary.str_aggressors_p) >= 3 and cash_hand_player_statistics.flg_f_saw, 1, 0])

The first part of this tests that there were 3 or more aggressors preflop. Check out this post if you want more information about the "aggressors" string.

also this is how i set the value expression for the first in raise success stat: (cnt_p_first_raise_success / cnt_p_first_raise) * 100

first raise success was the expression kraada gave me and first raise was an in built column , is it correct?

That seems fine.

Lastly i dont know if i should create new column for *saw flop in non-3bet pots* i saw you put - instead

Would this value expression work? (cnt_f_saw - cnt_f_saw_3bet_pot) , cnt_f_saw_3bet_pot is my own column with the expression i wrote above.

Yes, that would work.

[Suboptimal88]

at the filter session , is it possible to mix filters somehow to give the correct percentage? for example i add Player won hand 0.5-1.5bb and raise first in , since it show me only the hands i had won then the percentage is 100% , can i add something to this filter to give me the correct percentage? or you can only do this with hud stats?

[kraada]

If you remove the raiase for won hand you'd see the success percentage in that spot correctly. The filters apply to all data in the report and then you get the percentages in those situations.

[Suboptimal88]

I think it counts the times i won the pot after seeing a flop too , is it possible to remove it? i cant find any filter to do this

[kraada]

Add that you didn't see the flop if you want times you won preflop.

[Suboptimal88]

there is not such filter , i cant find it , there is one who say *saw flop* but its off , still im pretty sure it counts the times i have won after seeing a flop , the hud stat gives me a different percentage than the filter.

[kraada]

The way to do this is to add Saw Flop and use the Not Selected button to negate it - then you exclude all times you saw a flop. See this tutorial section for screenshots if you need more guidance.

[Suboptimal88]

it doesnt show all the hands i have raised with , it exclude those where i saw a flop , i need something like *raised first in and not saw flop OR *insert here the total of hands i have raised with* , i mean i need something to show me the total of hands i have raised first in but show the win percentage only for those where i didnt see a flop. You can do this with the hud stat but filters will show you the results of anything you put and if you choose not selected then it will remove the hand count as well , seems troublesome. is it possible to do what i ask?

[kraada]

Look through the filters tutorial - you can make complex OR statements as well to do exactly what you want.