tournaments vs reg
Posted: Wed Jan 17, 2024 11:16 am
HI,
I am trying to make a statistic of how many tournaments I am playing against fish.
In my report i can do this as follows (Excluding the regs), filter expression:
tourney_hand_player_statistics.id_hand NOT in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where (thps.id_player = p.id_player and
( p.player_name = 'villan X' OR p.player_name = 'villan Y')))
But, I need to create a statistic,well in statistics->columns I have cnt_tourneys with expression count(distinct tourney_summary.id_tourney),
when i add ''and tourney_hand_player_statistics.id_hand NOT in (SELECT thps.id_hand''......
It doesnt work
do you have some solution?
I need to create the reg % statistic.
I am trying to make a statistic of how many tournaments I am playing against fish.
In my report i can do this as follows (Excluding the regs), filter expression:
tourney_hand_player_statistics.id_hand NOT in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where (thps.id_player = p.id_player and
( p.player_name = 'villan X' OR p.player_name = 'villan Y')))
But, I need to create a statistic,well in statistics->columns I have cnt_tourneys with expression count(distinct tourney_summary.id_tourney),
when i add ''and tourney_hand_player_statistics.id_hand NOT in (SELECT thps.id_hand''......
It doesnt work
do you have some solution?
I need to create the reg % statistic.