Page 1 of 1

using Net Expected stats in a expression

PostPosted: Tue Jul 03, 2012 10:16 pm
by pt4pt4pt4
How do I use the graph line variables of Net Expected Chips Won & Net Expected BB Won in a custom stat?

i want to use them in a custom filter but not sure how to identify them in the expression.

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 4:32 am
by WhiteRider
The expression is:

cash_hand_player_statistics.amt_expected_won / cash_limit.amt_bb

..or for tournaments:

tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 9:56 am
by pt4pt4pt4
if i post either of these in a filter byitself and select validate, it says it is not valid.
How can i post each of these individualy in a filter to make sure i have the right format?

tourney_hand_player_statistics.amt_expected_won

tourney_blinds.amt_bb

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 10:32 am
by kraada
I'm not certain exactly what you're asking - could you be a bit more specific about what you're trying to do?

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 10:47 am
by pt4pt4pt4
I can't get each variable to validate byitself in a filter (trying to make sure that i am using it properly).

do i need a format of some type to display the stat?

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 1:11 pm
by kraada
You can't validate just that database field by itself in the Player section because in that statistics section the stats are based on groups of hands.

They should validate in the Hand section if you want to see that value for individual hands.

If you want to see them in the player section, by itself you could use:

sum(cash_hand_player_statistics.amt_expected_won)

And I'm not sure how you'd want to see the big blind size for groups of hands - the Blinds stat already uses that value and groups the hands into rows by blind level.

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 1:29 pm
by pt4pt4pt4
what i did was to create a test stat called Chips /BBWon and the expression is amt_chips_won / amt_bb_won and it works properly as it displays in the information box.

What i wanted to do now was replace amt_chips_won and use Net Expected Chips Won value, which you said is
tourney_hand_player_statistics.amt_expected_won which will not validate when I subsitute it in the expression.

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 3:15 pm
by kraada
That's because amt_chips_won and amt_bb_won are columns with their own definitions (which you can see if you scroll up and down and take a look).

You should just be able to use amt_expected_won (without the tourney_hand_player_statistics bit) and it should work just the same as amt_chips_won.

Re: using Net Expected stats in a expression

PostPosted: Wed Jul 04, 2012 7:58 pm
by pt4pt4pt4
Thanks for the answer, now I can reserve some brain cells for a day and go through

https://www.pokertracker.com/forums/viewtopic.php?f=45&t=22599,

and create my own test custom report and graph it (correct?)

Re: using Net Expected stats in a expression

PostPosted: Thu Jul 05, 2012 3:26 am
by WhiteRider
You can create your own custom report, but I'm not sure what you mean by "..and graph it"? You can add custom stats to the graph but you can't graph a custom report.