Notetracker - Error with a Note

[4StarGen]

I wanted to build a autonote that counts how many times a player 3bet an isoraise, so I made this 2 autonote



and



but clearly something isn't working as expecting since I'm getty way less result for the first stat.

I made the relative custom stat using these columns:
_3Bet_Iso

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_actors_p) >= 1 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int AND cash_hand_player_statistics.flg_p_3bet,1,0])

_3Bet_Iso_opp

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_actors_p) >= 1 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int AND cash_hand_player_statistics.flg_p_3bet_opp,1,0])

Now let's compare the 2 stats (the simple custom stat and the one made with custom notes)



as you can see the numerator and denominator are different




I just want to point out that these method is working for other stats like 3bets, so there's something wrong with the autonote definition



Well I guess I realized one of the problems... the issue with the numerator.
If I made a hand report and using a proper filter, I realized that the 6 hands are the hands which we see a showdown. The problem is, I didn't ask to notetaker to filter that.

http://i.imgur.com/RVHrnSZ.png

Regarding the denominator, I don't have a clue about the difference, maybe there's some spot that wasn't qualified...

Is this a bug tho?

[4StarGen]

UPDATE:

I just made a brand new autonote (not duplicate from the other one) and I called it P003



Now let's compare the test for the buggy stat and the new stat

http://i.imgur.com/NdjKNnU.png

lol? The same note yield different results?

I also check the autonote for the opportunities, and I got now strange behaviour.
The only issue is the different number of opportunities that are showing up. I'd like to check what is wrong with the note but I don't know how I can do that

[kraada]

I'm not sure why you're getting so few hits. Try creating it without using Opponent - you can filter to make sure that someone limped via Hand Details -> Preflop Limping That Occurred. Set that to >= 1 and then there must have been some limp and that takes care of your reason for needing an Opponent.

[4StarGen]

I'm not sure why you're getting so few hits. Try creating it without using Opponent - you can filter to make sure that someone limped via Hand Details -> Preflop Limping That Occurred. Set that to >= 1 and then there must have been some limp and that takes care of your reason for needing an Opponent.

In case you missed, I figure it out in my second post... still a bug tho.
Do you have any insights regarding the denominator?

[kraada]

Try creating another note for the denominator without ()s in it and let me know if that works better. It's kind of a shot in the dark but the only thing I can see that's different between the one you posted that didn't work and the one you posted that did.

[4StarGen]

Try creating another note for the denominator without ()s in it and let me know if that works better. It's kind of a shot in the dark but the only thing I can see that's different between the one you posted that didn't work and the one you posted that did.

It's not that... Now I know what it is all about.
The buggy note was a duplicate of this one


As you can see, there's a variable in it.
Well I found that the buggy note, even if it doesn't contain the variable in the string, it somewhat stored in the code...

Look what I've highlighted
http://i.imgur.com/p8D6GHB.png

so it was embedded in the stat once I hit the duplicate button

[WhiteRider]

Thanks for following up. We're aware of that restriction with Variables and I have reminded the development team about it for you.