Hero report vs specific vilain(s)

[Naeco]

Hi,

Is it possible de create a stats report of Hero but filter the stats against specific opponents ?

Thanks

[Flag_Hippo]

To see your stats/hands when a specific player was dealt in you can use this expression filter:

Code: Select all

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

Replace Villain with a screen name and leave the single quotes - those are needed. Note that this kind of report can take a little while to complete. You will need to replace "cash" with "tourney" if you are in a tournament report.

[Naeco]

Thanks !

[expost]

To see your stats/hands when a specific player was dealt in you can use this expression filter:

Code: Select all

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

Replace Villain with a screen name and leave the single quotes - those are needed. Note that this kind of report can take a little while to complete. You will need to replace "cash" with "tourney" if you are in a tournament report.

Can you please clarify where this change is made? Ty

[Flag_Hippo]

What change? The change for the name or the change for tournament hands? For the name you would need to substitute what I have highlighted in red for the player name you want:

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