Do any filters affect Place Finish in reports?

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Do any filters affect Place Finish in reports?

Postby kraada » Thu Jan 10, 2013 4:07 pm

If you want all tournaments wherein you held AA or KK at some point instead of:

tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps WHERE chps.flg_hero and chps.id_holecard in (1, 26))

you want:

tourney_hand_player_statistics.id_tourney in (SELECT chps.id_tourney from tourney_hand_player_statistics chps WHERE chps.flg_hero and chps.id_holecard in (1, 26))

And that should filter to only entire tournaments where you had AA or KK (which I think is what you're after).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Do any filters affect Place Finish in reports?

Postby pt4pt4pt4 » Thu Jan 10, 2013 5:23 pm

No, your filter counts every hand where as the one i posted did correctly count just A or K hands but multiplied the place finish times the occurence for each Tourny.

On point 2, how do I get the filter expression stat BB WON affect tourneys finish placings?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Do any filters affect Place Finish in reports?

Postby kraada » Thu Jan 10, 2013 7:11 pm

My filter should limit the tournaments in the list to only tournaments where you were dealt AA or KK, it shouldn't double count anything. Is that not what you are seeing?

I'm not sure how filtering on BB Won would make sense for tournaments. If you filtered for positive values you couldd see tournaments where you won chips early on (where the blind levels were low and hence you won many BBs) and then busted out later (when short).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Do any filters affect Place Finish in reports?

Postby pt4pt4pt4 » Thu Jan 10, 2013 9:20 pm

kraada wrote:My filter should limit the tournaments in the list to only tournaments where you were dealt AA or KK, it shouldn't double count anything. Is that not what you are seeing?

I'm not sure how filtering on BB Won would make sense for tournaments. If you filtered for positive values you couldd see tournaments where you won chips early on (where the blind levels were low and hence you won many BBs) and then busted out later (when short).


Running a Report for a specific day gives me:

    "1st Place","2nd Place","3rd Place","4th Place","5th Place","6th Place","7th Place","8th Place","9th Place","10th Place","Tourney Start","Tournaments"
    "0","0","0","0","0","1","0","0","0","0","2012/12/20 11:31 pm","1"
    "0","0","0","0","1","0","0","0","0","0","2012/12/20 11:32 pm","1"
    "0","0","0","0","1","0","0","0","0","0","2012/12/20 11:32 pm","1"
    "0","0","0","0","0","1","0","0","0","0","2012/12/20 11:34 pm","1"
    "0","1","0","0","0","0","0","0","0","0","2012/12/20 11:34 pm","1"
    "0","0","0","0","0","0","1","0","0","0","2012/12/20 11:36 pm","1"
    "0","0","0","0","0","1","0","0","0","0","2012/12/20 11:36 pm","1"

7 Tourneys total.
-----------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------

Including filter expression that I posted:
tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps WHERE chps.flg_hero and chps.id_holecard in (1, 26))[/b]

Gives me:
    "1st Place","2nd Place","3rd Place","4th Place","5th Place","6th Place","7th Place","8th Place","9th Place","10th Place","Tourney Start","Tournaments"
    "0","0","0","0","0","1","0","0","0","0","2012/12/20 11:31 pm","1"
    "0","5","0","0","0","0","0","0","0","0","2012/12/20 11:34 pm","1"
    "0","0","0","0","0","0","1","0","0","0","2012/12/20 11:36 pm","1
"

3 Tourneys total.
But notice 2nd trny has 5 which added up all AA or KK in the trny.
-----------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------

Including filter expression that you posted:
tourney_hand_player_statistics.id_tourney in (SELECT chps.id_tourney from tourney_hand_player_statistics chps WHERE chps.flg_hero and chps.id_holecard in (1, 26))

Gives me:
    "1st Place","2nd Place","3rd Place","4th Place","5th Place","6th Place","7th Place","8th Place","9th Place","10th Place","Tourney Start","Tournaments"
    "0","0","0","0","0","31","0","0","0","0","2012/12/20 11:31 pm","1"
    "0","77","0","0","0","0","0","0","0","0","2012/12/20 11:34 pm","1"
    "0","0","0","0","0","0","46","0","0","0","2012/12/20 11:36 pm","1"

3 Tourneys total.
But notice that the high numbers reflect total of number hands in the whole trny.
-----------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------

I would like to also be able to filter like this also on BB WON and Stack Size > ?? in order to plug a few leaks when I get way ahead in a trny and start to fk around like an idiot. Isolating these trnys will show me how much i lost in winnings.
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Do any filters affect Place Finish in reports?

Postby pt4pt4pt4 » Fri Jan 11, 2013 2:53 pm

I can clean up your stat by exporting to a spreadsheet and sorting it.

Looked into the Statistics option and found this for BB Won.

tourney_hand_player_statistics.amt_won / tourney_blinds.amt_bb

So I could replace your line with this option?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Do any filters affect Place Finish in reports?

Postby pt4pt4pt4 » Fri Jan 11, 2013 5:27 pm

pt4pt4pt4 wrote:I can clean up your stat by exporting to a spreadsheet and sorting it.

Looked into the Statistics option and found this for BB Won.

tourney_hand_player_statistics.amt_won / tourney_blinds.amt_bb

So I could replace your line with this option?


tourney_hand_player_statistics.amt_won / tourney_blinds.amt_bb that doesn't work.

Any suggestions?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Do any filters affect Place Finish in reports?

Postby kraada » Fri Jan 11, 2013 5:42 pm

In order to use that you'd need to also join to the tourney_blinds table like so:


tourney_hand_player_statistics.id_hand in (SELECT chps.id_tourney from tourney_hand_player_statistics chps, tourney_blinds tb WHERE tb.id_blinds = chps.id_blinds and chps.flg_hero and chps.amt_won / tb.amt_bb > X)

And you can fill in the X (you can also use BETWEEN X and Y if you so desire).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 27 guests