divide stats between KO and not KO tournaments

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

divide stats between KO and not KO tournaments

Postby 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

Re: divide stats between KO and not KO tournaments

Postby 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: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: divide stats between KO and not KO tournaments

Postby 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

Re: divide stats between KO and not KO tournaments

Postby 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: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: divide stats between KO and not KO tournaments

Postby 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

Re: divide stats between KO and not KO tournaments

Postby 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: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: divide stats between KO and not KO tournaments

Postby 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

    Re: divide stats between KO and not KO tournaments

    Postby 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

    Re: divide stats between KO and not KO tournaments

    Postby BillGatesIII » Thu Jun 07, 2018 10:06 am

    Yep.
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm

    Re: divide stats between KO and not KO tournaments

    Postby 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: 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 24 guests

    cron