Page 1 of 2

divide stats between KO and not KO tournaments

PostPosted: Wed Apr 18, 2018 6:04 am
by afteRReset
Is there a way to do that using custom stats? Or maybe something else?

Re: divide stats between KO and not KO tournaments

PostPosted: Fri Apr 20, 2018 2:31 am
by WhiteRider
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).

Re: divide stats between KO and not KO tournaments

PostPosted: Sat May 05, 2018 6:02 am
by afteRReset
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?

Re: divide stats between KO and not KO tournaments

PostPosted: Sat May 05, 2018 9:20 am
by WhiteRider
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.

Re: divide stats between KO and not KO tournaments

PostPosted: Wed May 09, 2018 7:11 pm
by afteRReset
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?

Re: divide stats between KO and not KO tournaments

PostPosted: Thu May 10, 2018 11:09 am
by Flag_Hippo
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.

Re: divide stats between KO and not KO tournaments

PostPosted: Sat May 19, 2018 12:52 pm
by BillGatesIII
    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%')

    Re: divide stats between KO and not KO tournaments

    PostPosted: Thu Jun 07, 2018 6:09 am
    by artorollin
    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

    Re: divide stats between KO and not KO tournaments

    PostPosted: Thu Jun 07, 2018 10:06 am
    by BillGatesIII
    Yep.

    Re: divide stats between KO and not KO tournaments

    PostPosted: Thu Jun 07, 2018 10:58 am
    by Flag_Hippo
    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.

    highfalutin