Do any filters affect Place Finish in reports?

[kraada]

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).

[pt4pt4pt4]

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?

[kraada]

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).

[pt4pt4pt4]

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]

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]

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?

[kraada]

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).