Page 1 of 1

tournaments vs reg

PostPosted: Wed Jan 17, 2024 11:16 am
by lucaianna7
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.

Re: tournaments vs reg

PostPosted: Wed Jan 17, 2024 2:04 pm
by Flag_Hippo
I'm not aware of a method to achieve that and unfortunately it's beyond my own knowledge of SQL so I can't comment on how feasible it would be.

highfalutin