Does this look like i would be getting the desired results?
A custom stat that includes checks, but not checks where they had the opportunity to donk...
I created a new check column cnt_f_check_no_donks hopefully only counting checks where they could have cbet or float bet (my main issue is knowing if this is correct).. the part ive bolded and made smaller is just a full copy of the float_opp collumn if that makes it easier to read without needing to look tOo hard into that section:
sum(if[(cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.flg_f_cbet_opp) OR (cash_hand_player_statistics.flg_f_check AND (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_open_opp AND char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position))) , 1, 0])
Then i went back and put that new check column into a duplicate of the Flop AFq stat
((cnt_f_bet + cnt_f_raise) / (cnt_f_call + cnt_f_fold + cnt_f_bet + cnt_f_raise + cnt_f_check_no_donks)) * 100