specify card rank ranges on flop

[diggingdeeply]

hello.

i would like to create a custom Cash Player Statistics report where i look at a player's stats when the flop has a certain texture involving hand ranges. namely, one card exactly an Ace, one card in the range of ten to king, and one card in the range 2 - 9. help, please! thanks.

[gkeuler]

Within the reports tab click filters (located above the available stats) then hit simple filters. Go to the texture tab within the new window, next "flop contains" checkboxes = Any A (add selected to filters) then K,Q,J,T(add selected),then 2-9 (add to filters) finally in the selected filters box just drag to hi light all three then hit the "AND Selected" button.

fairly certain that will accomplish it

[kraada]

It should.

[diggingdeeply]

thank you very much for your help!
now a harder one (I think):
If I want two cards to be in the SAME range, e.g. T-K.
If I check Any K, Any Q, Any J, Any T, add the filter, then again specify Any K, Any Q, Any J, Any T, add filter, and then join the two filters by AND, the two filters are treated as one. That is, I get the same results if I use just one filter or both. Makes sense, since they are the same filter.
Anyone see a solution without coding it? And how would I begin to code it??

[gkeuler]

the exact format probably depends what exact textures ur looking for but a problem like that could be solved with 'OR Selected' which creates a differnt filter for slightly differnt paramaters. this does exponetially increase your amount of clicking though :(

this is a combinatorics/permutations thing and I suck at math, the simple filters though should be able to filter for every possible permutation, atleast for ranks as far as I know

[kraada]

Easiest then is going to be building a SQL filter (which will only work in your custom report).

For exactly two cards in the T-K range, with no aces you'll want this filter:

(holdem_hand_summary.card_1 % 13 BETWEEN 9 and 12 AND (holdem_hand_summary.card_2 % 13 BETWEEN 9 and 12 OR holdem_hand_summary.card_3 % 13 BETWEEN 9 and 12)) OR (holdem_hand_summary.card_2 % 13 BETWEEN 9 and 12 AND holdem_hand_summary.card_3 % 13 BETWEEN 9 and 12)

Just put that in the box provided in the blue Filters section and it should work once you click Save.

Edit to add: This way also saves on clicking :)