Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
- amt_won - amt_chips = 0
pt4pt4pt4 wrote:I use this in the expression filter for my report:
- Code: Select all
- amt_won - amt_chips = 0
Now you can customize the games with quick filters, so if you play SNGs and Satellite / MTT Rebuys, have a quick filter for the SNG description. Also have a OR for the Rebuy flag description, but include greater then for the the blind level after the Rebuys/addons are over.
select distinct on (id_tourney) id_hand
from tourney_hand_summary
order by id_tourney, id_hand desc
id_hand = (select max(ths.id_hand) from tourney_hand_summary ths where ths.id_tourney = tourney_hand_player_statistics.id_tourney)
id_hand in (
select s.id_hand
from (
select ths.id_hand, max(ths.id_hand) over (partition by ths.id_tourney) last_hand
from tourney_hand_summary ths) as s
where s.id_hand = s.last_hand)
exists (
select 1
from (
select ths.id_tourney, max(ths.date_played) over (partition by ths.id_tourney) last_played
from tourney_hand_summary ths) as ths_hands
where tourney_hand_summary.date_played = ths_hands.last_played
and tourney_hand_summary.id_tourney = ths_hands.id_tourney)
BillGatesIII wrote:
Anyway, getting back to the original question, I think this expression will work.
- Code: Select all
exists (
select 1
from (
select ths.id_tourney, max(ths.date_played) over (partition by ths.id_tourney) last_played
from tourney_hand_summary ths) as ths_hands
where tourney_hand_summary.date_played = ths_hands.last_played
and tourney_hand_summary.id_tourney = ths_hands.id_tourney)
If you put this into an Expression Filter, you'll get every last hand played of a tourney.
Lastly, if you only want the bust out hands, add a simple filter 'Player Lost Hand'.
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: djphan and 28 guests