Best stat for working on hero calls?

[PokerBot]

Thanks for that stat; i dont see much difference between my "hero calling" even when i use different filters like 6max, shorthanded PKO etc which should obviously affect the results so i think its best to go down the route of having a WTSD stat but without the preflop all ins
From the link in the thrid post white rider said to make it this (i changed cash to tourney)

sum(if[tourney_hand_player_statistics.flg_showdown AND lookup_actions_f.action LIKE '_%', 1, 0])

I copied the WTSD stat and copied the above formula into the definitions tab but it always says "invalid value expression when i try to save it, even when i put a space, press enter or delete the other formula already in the "Definition" window

[Flag_Hippo]

That information does not get entered on the definitions tab for your custom statistic. If you look at the existing 'Value Expression' for WTSD you will see this:

Code: Select all

(cnt_wtsd / cnt_f_saw) * 100

cnt_wtsd and cnt_f_saw are columns which are the building blocks of statistics and you can view those by clicking on the 'Columns' tab. The cnt_wtsd column counts how often a player gets to showdown and the cnt_f_saw column counts how often a player sees the flop so if you divide cnt_wtsd by cnt_f_saw and multiply by 100 (as per the value expression) it gives the percentage of how often a player gets to showdown given that they saw the flop. Now what you need to do is edit these columns to exclude the preflop all-ins and you do that by first duplicating and editing the built-in columns. For example:

cnt_wtsd

Code: Select all

sum(if[tourney_hand_player_statistics.flg_showdown, 1, 0])

gets changed to:

cnt_wtsd_no_pf_ai (you can give the custom column a different name if you prefer).

Code: Select all

sum(if[tourney_hand_player_statistics.flg_showdown AND lookup_actions_f.action LIKE '_%', 1, 0])

cnt_f_saw

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_saw, 1, 0])

gets changed to:

cnt_f_saw_no_pf_ai

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_saw AND lookup_actions_f.action LIKE '_%', 1, 0])

The value expression for your custom statistic can now be created with:

Code: Select all

(cnt_wtsd_no_pf_ai / cnt_f_saw_no_pf_ai) * 100

[PokerBot]

Hi, thanks for the detailed response in helping me understand the syntax

To confirm i went to "configure", "statistics", then "colums", searched for "WTSD", duplicated it, then entered this into the "expression" window

sum(if[tourney_hand_player_statistics.flg_f_saw AND lookup_actions_f.action LIKE '_%', 1, 0])

It saved correctly but when i added the stat to my "statistics" tab within the main poker tracker program, grouped by "posistion" and added the stat, the data was exactly the same as the normal WTSD, over a 30k sample

Do i need to leave in the first formal and paste the new formula directly after it, with a space, after pressing "enter" on my keyboard or do i need to add every single line of code that you posted in your last replay? Thanks for the help

[PokerBot]

... I tired doing it again from scratch and now it is saying "The statement is not valid SQL"

[Flag_Hippo]

First you need to create the two custom columns and then what that's done you create the custom statistic which uses those columns:

[PokerBot]

Hi, i tired what you said and got the popup "statistic is valid" but when i try to use the stat in my "Statistics" tab the numbers are all "100" even when trying different"group by" settings

I have exported the statistic to see if that helps with troubleshooting

[Flag_Hippo]

Your cnt_wtsd_no_pf_ai column is not correct and has exactly the same expression as the other column (cnt_wtsd_no_pf_ai) so to fix that you need to change the tourney_hand_player_statistics.flg_f_saw in cnt_wtsd_no_pf_ai to tourney_hand_player_statistics.flg_showdown.

[PokerBot]

I tired it all from scratch and got the following error message when trying to use the stat (picture01)

I also got a popup saying something like statistic is not cacheable

I have included all other pop ups and the exported stat

[Flag_Hippo]

In the first version you attached you had the cnt_wtsd_no_pf_ai column defined as follows:

cnt_wtsd_no_pf_ai
sum(if[tourney_hand_player_statistics.flg_f_saw AND lookup_actions_f.action LIKE '_%', 1, 0])

if you just change tourney_hand_player_statistics.flg_f_saw to tourney_hand_player_statistics.flg_showdown as I suggested in my previous reply that would leave you with this:

cnt_wtsd_no_pf_ai
sum(if[tourney_hand_player_statistics.flg_showdown AND lookup_actions_f.action LIKE '_%', 1, 0])

but what you did in the second version of the stat you attached was remove everything else from the column and that just breaks the stat:

cnt_wtsd_no_pf_ai
tourney_hand_player_statistics.flg_showdown

[Qetz]

A competent player should have a Call River Eff of 1.1 or so if he filters High Cards/ Third Pairs in river right?