Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by afteRReset » Wed Apr 18, 2018 6:04 am
Is there a way to do that using custom stats? Or maybe something else?
-
afteRReset
-
- Posts: 49
- Joined: Thu Jun 13, 2013 9:11 am
by WhiteRider » Fri Apr 20, 2018 2:31 am
If you mean bounty tournaments then you can filter for those using built in filters. You can use the tournament Flags checkboxes in the sidebar on the left of the reports, or you can use the
Filters Window (that filter is in Game Details > Tournament Flags).
-
WhiteRider
- Moderator
-
- Posts: 54017
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by afteRReset » Sat May 05, 2018 6:02 am
WhiteRider wrote:If you mean bounty tournaments then you can filter for those using built in filters. You can use the tournament Flags checkboxes in the sidebar on the left of the reports, or you can use the
Filters Window (that filter is in Game Details > Tournament Flags).
I would like to filter hud stats so that when I play a knockout tournament the hud shows knockout stats and when I play regular no bounty tournament regular stats are shown.
I imagine there's no simple way to do that. So the question is how to filter it in custom stat, by the name of tournament or by the existing of bounty. How do I do that?
-
afteRReset
-
- Posts: 49
- Joined: Thu Jun 13, 2013 9:11 am
by WhiteRider » Sat May 05, 2018 9:20 am
No, there's no way to do that because we can't determine the type of tournament until tournament detection runs when the tournament ends.
-
WhiteRider
- Moderator
-
- Posts: 54017
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by afteRReset » Wed May 09, 2018 7:11 pm
WhiteRider wrote:No, there's no way to do that because we can't determine the type of tournament until tournament detection runs when the tournament ends.
Is there maybe buy-in stat or column available, since knock and regular tournaments I play have different buy-in I could sort them with that?
-
afteRReset
-
- Posts: 49
- Joined: Thu Jun 13, 2013 9:11 am
by Flag_Hippo » Thu May 10, 2018 11:09 am
The buy-in for the current tournament wouldn't be known and something like this isn't possible with a regular custom statistic. There may be a more advanced way of doing this but I am afraid that's beyond my own knowledge.
-
Flag_Hippo
- Moderator
-
- Posts: 15136
- Joined: Tue Jan 31, 2012 7:50 am
by BillGatesIII » Sat May 19, 2018 12:52 pm
You'll have to add this piece of code to your columns.
- Code: Select all
and exists (
select 1
from tourney_hand_player_statistics as thps
join tourney_summary as ts on ts.id_tourney = thps.id_tourney
join tourney_table_type as ttt on ttt.id_table_type = ts.id_table_type
where thps.id_hand = tourney_hand_player_statistics.id_hand
and ttt.val_flags like '%B%')
-
BillGatesIII
-
- Posts: 740
- Joined: Fri Dec 16, 2011 6:50 pm
by artorollin » Thu Jun 07, 2018 6:09 am
Does that mean i would have to add
and exists (
select 1
from tourney_hand_player_statistics as thps
join tourney_summary as ts on ts.id_tourney = thps.id_tourney
join tourney_table_type as ttt on ttt.id_table_type = ts.id_table_type
where thps.id_hand = tourney_hand_player_statistics.id_hand
and ttt.val_flags like '%B%')
to every single stat and when every single stat is customized for KOs i create a new HUD profile with those so i can switch between em?
cheers
-
artorollin
-
- Posts: 7
- Joined: Thu Jan 29, 2015 10:57 pm
by Flag_Hippo » Thu Jun 07, 2018 10:58 am
Bear in mind that this will only display HUD stats for tournaments that have been finished and detected. Hands for the current tournament will not be displayed in the HUD with a stat like that as detection doesn't run until the tournament finishes.
-
Flag_Hippo
- Moderator
-
- Posts: 15136
- 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