Need help with report

[none888]

Hi,
I make new report -> new all player report, it shows players I have played in single row and i can add/remove stats.
Id like to know how I can filter players by name, I guess I will need to use expression filter?
Like for today there is list of players:
player1
player2
player3
player4
player5

and I want filter for example that report shows me only player1 and player2 and player3.
thanks

[WhiteRider]

Check out this post which explains how to do this.
If you're playing cash tables replace tourney_ with cash_ in the filter expression.

[none888]

Code: Select all

( 0 < (SELECT count(hhps2.id_hand) FROM tourney_hand_player_statistics hhps2 WHERE hhps2.id_hand = tourney_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='Villain') ) )

ok, how do I edit it so i can select many players, it will be smtx like WHERE player_name='Villain' or player_name='Villain2' or .. etc ?

[kraada]

Yep, you an OR in as many player names as you'd like.

[none888]

I put this filter:

( 0 < (SELECT count(hhps2.id_hand) FROM tourney_hand_player_statistics hhps2 WHERE hhps2.id_hand = tourney_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='Villain' OR player_name='villain2') ) )

Its valid expression but I get this:
https://lh4.googleusercontent.com/-7FDyTeSWSps/UROp4BuUNTI/AAAAAAAABLo/L7t3kS2C7YU/s1463/error.png

Just to be clear what I want, here is just all player report:

I play HU sng and I just want to see how Im doing vs certain players, I could just search them one by one but if there is like 20 players than its becoming complicated to see overall results like tournies played, hands played, net win, net adjusted, overall roi etc

[kraada]

You don't need a custom report for this - take a look on the Results page at the Hero vs Villain report. Since you're playing heads up, chips won translates very directly to actual money won so you should be able to use that report for nearly everything you want to do.

[none888]

Ok I found it, but there all players I have played obv.
How do I remove players I dont want to see in that list?
Also can I configure stats in that report? chips won is fine and yea they directly translates to money, but I want to see ev winnings, even in chips would be fine.

[kraada]

Unfortunately due to the way the report needs to be created it is not configurable. However, I will mention possibly adding expected winnings to that report to the developers and see if it's something we can add in the future.

[none888]

So how than I can remove players from this list or filter only those I want by name? Is it possible?

[kraada]

In the blue Filters link you can add Filter Expressions to filter that list.

If you want players in the list you'd need a line like:
#Player# = 'Screen Name'

To exclude a player:
#Player# != 'Screen Name 2'

You can also filter based on other stat values - click the blue Insert link to see the options; you could do things like:
#Hands# > 1000
or
#VPIP# < 35
and those may be useful for you.