multi filter working

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

multi filter working

Postby WaitWaitW » Thu Jul 08, 2021 5:57 am

Hi ! I would like to make a custom report for all players except me where each row represents hole cards.

The custom report for all players except me works well with filter expression
#Player# <> 'me'.

The custom report for all players where each row represents hole cards works well with filter expression
cash_hand_player_statistics.id_holecard in (SELECT cash_hand_player_statistics.id_holecard from cash_hand_player_statistics group by cash_hand_player_statistics.id_holecard)

But, when I put those two expressions, hole ccards are not grouped.

So the question : is there a way to "stack" those 2 expression filters ?

Thanks :)
WaitWaitW
 
Posts: 79
Joined: Fri Aug 03, 2012 4:21 am

Re: multi filter working

Postby Flag_Hippo » Thu Jul 08, 2021 12:29 pm

If I am understanding correctly what you want to see then you can do this without using expression filters. Create an 'All Players' report, remove the 'Player' stat and then add the 'Hole Cards' statistic along with any others you want. Add a simple filter for NOT(Player is Hero) to remove your own data and then you'll see the overall population's range of hands shown down along with a line for hole cards that's blank which is for the unknown hands.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: multi filter working

Postby WaitWaitW » Fri Jul 09, 2021 7:37 am

so simple, so good. :mrgreen:
Thank you !
WaitWaitW
 
Posts: 79
Joined: Fri Aug 03, 2012 4:21 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 17 guests

cron
highfalutin