Expression filter for "no final table" hands

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby PetarM » Thu Dec 13, 2018 9:40 am

Thank you
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby 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

Re: Expression filter for "no final table" hands

Postby 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
PT.JPG
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: Expression filter for "no final table" hands

Postby 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
PT1.JPG
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: Expression filter for "no final table" hands

Postby 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

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 23 guests

cron