Equivalent stats return different values

[erdnase17]

I made a simple column called cnt_p_face_minr to count the number times a player faced a minraise in heads up games, which has the definition:

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])


If I run this stat for a particular villain it will return some value.

Then I made another column called cnt_p_minr that counts the number of times a player minraised. The definition is:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_att and tourney_hand_player_statistics.amt_p_raise_made = 2 * tourney_blinds.amt_bb, 1, 0])

Now If I run a report for hero with a stat based on the latter column, filtering only for hands against this particular villain with:

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'villain sn here')

it will return a different value.

Why the discrepancy? One of the columns must be incorrect, which is it?

Thanks

[erdnase17]

I tried changing the cnt_p_faced_minr to

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp and tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])

and I got slightly closer results but still different.

Any ideas?

[kraada]

There's a key piece of information you're missing here - that is that the amt_p_raise_facing value is based on how much the player needs to call - not the total amount the raise was to.

So when you open for a minraise the player in the big blind (assuming all others fold) has an amt_p_raise_facing of 1 BB - not 2BB.

That almost certainly accounts for your entire discrepancy (this affects the SB too, obviously).

[erdnase17]

There's a key piece of information you're missing here - that is that the amt_p_raise_facing value is based on how much the player needs to call - not the total amount the raise was to.

So when you open for a minraise the player in the big blind (assuming all others fold) has an amt_p_raise_facing of 1 BB - not 2BB.

That almost certainly accounts for your entire discrepancy (this affects the SB too, obviously).

I am not sure I am following you.
The definition of cnt_p_face_minr is using 1 bb as the amount amt_p_raise_facing:

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])

When you say it affects the SB what do you mean? The amt_p_raise_made should be 2 bb right? (I tried 1 bb and it won't work...)

Thanks.

[kraada]

Sorry, I missed that we were talking about exclusively heads up.

I'm not sure why these wouldn't be identical then. How far off are they?

[erdnase17]

Sorry, I missed that we were talking about exclusively heads up.

I'm not sure why these wouldn't be identical then. How far off are they?

About 5-7 hands.

[kraada]

Out of how many?

[erdnase17]

Out of how many?

The report is 1691 hands.

[kraada]

I think the best way to figure this out might well be to make Hand reports and then compare the actual hand numbers from the two reports. If you include hole cards and hand numbers it might not take too long to find one hand that doesn't match - and once you find one, we'll be able to figure out what is going on here.

[erdnase17]

I think the best way to figure this out might well be to make Hand reports and then compare the actual hand numbers from the two reports. If you include hole cards and hand numbers it might not take too long to find one hand that doesn't match - and once you find one, we'll be able to figure out what is going on here.

I tried that but the Hand Reports won't accept custom stats...