Filtering tournaments by opponent.

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Filtering tournaments by opponent.

Postby LetTheAceKik » Wed Sep 08, 2021 8:23 am

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.
LetTheAceKik
 
Posts: 5
Joined: Wed Jun 25, 2008 1:12 pm

Re: Filtering tournaments by opponent.

Postby Flag_Hippo » Wed Sep 08, 2021 10:29 am

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'.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Filtering tournaments by opponent.

Postby LetTheAceKik » Wed Sep 08, 2021 11:47 am

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
 
Posts: 5
Joined: Wed Jun 25, 2008 1:12 pm

Re: Filtering tournaments by opponent.

Postby LetTheAceKik » Wed Sep 08, 2021 12:24 pm

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

Thanks.
LetTheAceKik
 
Posts: 5
Joined: Wed Jun 25, 2008 1:12 pm

Re: Filtering tournaments by opponent.

Postby Flag_Hippo » Thu Sep 09, 2021 5:30 am

LetTheAceKik wrote: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'.
LetTheAceKik wrote: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).
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Filtering tournaments by opponent.

Postby LetTheAceKik » Thu Sep 09, 2021 1:48 pm

I was talking about results-report-player summary. That gives me stats on all the players I've played.
LetTheAceKik
 
Posts: 5
Joined: Wed Jun 25, 2008 1:12 pm

Re: Filtering tournaments by opponent.

Postby Flag_Hippo » Fri Sep 10, 2021 4:53 am

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.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Filtering tournaments by opponent.

Postby LetTheAceKik » Mon Sep 13, 2021 12:28 am

Do you have a telephone contact line?
LetTheAceKik
 
Posts: 5
Joined: Wed Jun 25, 2008 1:12 pm

Re: Filtering tournaments by opponent.

Postby Flag_Hippo » Mon Sep 13, 2021 6:33 am

We do not have a telephone support service. We have our forums here or you can submit a Support Ticket.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 32 guests

cron