Q1. is there something similar to the PT3 schema documentation where i can look to see what a specific column does what? like a glossary of sorts? it would be very helpful
Q2. I was looking on the Schema but didn't find any info on char_length, what does this do? The reason why i ask is because i have a
"bet turn in limped pot stat"
and i was told that char_length(tourney_hand_summary.str_aggressors_p) = 1 specifies that it was a limped pot,
Q3. but also NOT(tourney_hand_player_statistics.flg_p_face_raise) specifies that it was a limped pot. (or im just wrong about this and also have to add more columns like flg_p_limp?
i have two stats:
1. Bet Turn (limp pot)
(cnt_t_bet_limp_pot / cnt_t_open_opp_limp_pot) * 100
cnt_t_bet_limp_pot:
sum(if[tourney_hand_player_statistics.flg_t_bet AND
NOT(tourney_hand_player_statistics.flg_p_face_raise) and lookup_actions_f.action='X', 1, 0])
cnt_t_open_opp_limp_pot:
sum(if[tourney_hand_player_statistics.flg_t_open_opp AND
not(tourney_hand_player_statistics.flg_p_face_raise) and lookup_actions_f.action='X', 1, 0])
2. Bet Turn (limp pot) (Copy)
(cnt_t_bet_limp_pot_copy / cnt_t_open_opp_limp_pot_copy) * 100
cnt_t_bet_limp_pot_copy:
sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 and tourney_hand_player_statistics.flg_t_bet and lookup_actions_f.action = 'X', 1, 0])
cnt_t_open_opp_limp_pot_copy:
sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 and tourney_hand_player_statistics.flg_t_open_opp and lookup_actions_f.action = 'X', 1, 0])
But i noticed that the first stat seems to capture more opportunities compared to the second.
Q4. so which stat is correct/more accurate? because whichever one you use you should have the same values