aggregated statistics versus a group of opponents

[loosefish]

Hello.
I regularly check my stats (eg, BB/100 in HU, in SB as well as in BB).

I would like to have these HU stats , but aggregated versus a certain group of opponents.
e.g., measure BB/100 on HU, in SB as well as in BB, as an aggregated figure against all opponents for which I have less than 100 hands (which I will call the "recreative players" Group), and aggregated figure against all opponents for which I have more than 100 hands (which I will call the "regs" Group)

How can we do it in PT4?

It is a useful feature avalaible with some competitors of PT4, so it would be very important to be able to do it in PT4.

Thank you by advance.

[Flag_Hippo]

Try this filter:

Code: Select all

tourney_hand_player_statistics.cnt_players = 2 and tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand FROM tourney_hand_player_statistics thps INNER JOIN tourney_cache tc ON thps.id_player = tc.id_player WHERE thps.flg_hero = false GROUP BY thps.id_hand, thps.id_player HAVING sum(tc.cnt_hands) < 100)

You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

[loosefish]

Thank you for the answer.
I took a few days to make several attempts, but it seems that PT4 does not manage to show stats with this filter. It seems to be working (for hours) and not being able to conclude (cf screenshots). I even tried with only one day of data, but still the same situation.
Do I have to do something differently ?

[Flag_Hippo]

I've tested the filter and it works with near instant results on a small database. If you are using any built-in filters do not use them as they may not work well combined with the expression filter. If you want to use any additional filters add them as expression filters. Also the subquery is performance intensive and will take longer the larger the database is.

[loosefish]

I don't know why, but it stalls when I do it on my side (actually, i have never seen it finishing the calculation and showing the stats).
On the example below, I removed all filters and chose only one day stats (yesterday), so only a few hundred hands. Do you have an idea of what creates this delay on my side?

[Flag_Hippo]

You are still using built-in filters:

Game: Holdem
Date: Yesterday
Flags: {unknown}

Click 'Clear All Filters Above' and try again and let it run with no filters except the expression filter. If you want to use any additional filters later you will need to add them as expression filters.