WTSD without preflop all ins

[sky44]

This is the first stat I've created—could you check to see if I made any mistakes?

1st column cnt_wtsd_no_ai (type sum)

Code: Select all

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

2nd column cnt_f_saw_no_ai (type sum)

Code: Select all

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

final statistic WTSD (no preflop all-in)

Code: Select all

( cnt_wtsd_no_ai / cnt_f_saw_no_ai ) * 100

Format: Percentage
Decimals: Yes


this stat work, but will it actually show me WTSD, excluding preflop all-ins?

[Flag_Hippo]

Yes that's correct.