Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by PetarM » Thu Dec 13, 2018 5:36 am
Hello,
I am playing 18 players MTT with 6 players per table and 3 starting tables.
I would like to be able to isolate the hands which are not from the final table only when there are 3 and 2 tables.
Could you please point me an expression filter for that
Thank you
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by Flag_Hippo » Thu Dec 13, 2018 8:39 am
There isn't a filter for final table hands but you could use an expression filter
like this which calculates final table hands from the starting stacks and number of players (you will need to enter the starting stack size and
NOT the filter since you don't want final table hands and if you have other tournaments in your database you will also need to add a simple filter for this type of tournament).
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by PetarM » Thu Dec 13, 2018 9:40 am
Thank you
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by PetarM » Thu Dec 13, 2018 9:50 am
Actually, if I put an expression filter that calculates the sum of all stacks (in chips) and the sum is inferior to 9000 that means that this is not a final table.
Can you give me an expression filter for the stack in chips of a given position please?
Thank you in advance
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by Flag_Hippo » Thu Dec 13, 2018 2:05 pm
PetarM wrote:Actually, if I put an expression filter that calculates the sum of all stacks (in chips) and the sum is inferior to 9000 that means that this is not a final table.
Yes you can do that with this:
- Code: Select all
tourney_hand_player_statistics.id_hand in (
select id_hand
from (
select distinct
thps.id_tourney
,thps.id_hand
,sum(thps.amt_before) over (partition by thps.id_hand) < 9000 as ft
from tourney_hand_player_statistics as thps
join tourney_summary as ts on ts.id_tourney = thps.id_tourney) as mtt
where mtt.ft)
PetarM wrote:Can you give me an expression filter for the stack in chips of a given position please?
What's going on at the other tables (number of players and stack sizes) isn't known so you can't calculate that.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by PetarM » Thu Jan 03, 2019 7:14 am
Hello,
The filter works, but it doesn't show a number of hands but starts populating hands even in "Player" filter.
With about 1M hands it takes really long time.
Could you suggest another way?
Could for example the sum of the chips of each position work better?
Thank you
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by Flag_Hippo » Thu Jan 03, 2019 1:31 pm
Filters like this can generate a lot of PostgreSQL processing so can take a while to complete if you have a large database and I don't know of another filter that's more efficient than the one I've already posted.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by PetarM » Fri Jan 04, 2019 8:37 am
Hello, ok
What about the fact, that the filter doesn't show one row with a certain number of hands in "Player" report?
Check this out, actually it populated 800k rows which corresponds to the total amount of hands in the database:
- Attachments
-
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by PetarM » Fri Jan 04, 2019 8:45 am
Actually it doesn't work, the filter actually shows all the hands, not only those which are with 3000 chips in total at the table (the current example)
- Attachments
-
-
PetarM
-
- Posts: 58
- Joined: Wed Oct 18, 2017 4:25 pm
by Flag_Hippo » Fri Jan 04, 2019 2:37 pm
Alot of those are the same hand repeated from every players perspective. This expression also uses a subquery similar to your other thread so you either need to turn on the 'Filter On Active Player' option or add a simple filter for a specific player position e.g. the Big Blind.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 23 guests