Filtering tournaments by opponent.

[LetTheAceKik]

Hi, I'm looking for a way to find out my finishing positions against individual players by tournament we both entered.
For example, say I've played 1000 SNGs and player 'X' played in 100 of these. I want to be able to filter these tournaments
out from the 1000 to find out how I did in just these tournaments. If I get ITM 35% of the time overall but only 33% of the
time when player 'X' is playing, then that would be useful to know. I can't find a way of tagging tournaments, is there
any other way?

Cheers.

[Flag_Hippo]

You can do this in a custom player report with the following expression filter and the statistics you want to see:

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Villain')

where 'Villain' is the opponents name (leave the single quotes - those are needed). You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

[LetTheAceKik]

Thanks Hippo, I tried that link and just got some player stats about hands.
How do I find out about finishing positions in tournaments?

Cheers.

[LetTheAceKik]

Also, what's the difference between player report and player summary?

Thanks.

[Flag_Hippo]

Thanks Hippo, I tried that link and just got some player stats about hands.
How do I find out about finishing positions in tournaments?

Add the following statistics to your 'Player' report:

1. 'Tournaments'.
2. 'Average Finish'.
3. 'ITM'.

Also, what's the difference between player report and player summary?

There isn't a 'player summary' in custom reports so I don't understand what you are asking here. There are three types of custom report:

1. 'Player' report (data for the active/selected player).
2. 'All Players' report (data for all players).
3. 'Hand' report (individual hand data).

[LetTheAceKik]

I was talking about results-report-player summary. That gives me stats on all the players I've played.

[Flag_Hippo]

To get the information you asked for in your original post requires the use of a custom expression filter and that can only be used in a custom report.

[LetTheAceKik]

Do you have a telephone contact line?

[Flag_Hippo]

We do not have a telephone support service. We have our forums here or you can submit a Support Ticket.