Page 1 of 2
Need help with report
Posted:
Thu Feb 07, 2013 4:30 am
by 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
Re: Need help with report
Posted:
Thu Feb 07, 2013 4:39 am
by 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.
Re: Need help with report
Posted:
Thu Feb 07, 2013 5:12 am
by 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 ?
Re: Need help with report
Posted:
Thu Feb 07, 2013 9:01 am
by kraada
Yep, you an OR in as many player names as you'd like.
Re: Need help with report
Posted:
Thu Feb 07, 2013 9:32 am
by 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.pngJust 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
Re: Need help with report
Posted:
Thu Feb 07, 2013 11:25 am
by 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.
Re: Need help with report
Posted:
Thu Feb 07, 2013 12:40 pm
by 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.
Re: Need help with report
Posted:
Thu Feb 07, 2013 1:59 pm
by 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.
Re: Need help with report
Posted:
Thu Feb 07, 2013 2:53 pm
by none888
So how than I can remove players from this list or filter only those I want by name? Is it possible?
Re: Need help with report
Posted:
Thu Feb 07, 2013 3:06 pm
by 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.