using Net Expected stats in a expression

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

[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

[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

[kraada]

I'm not certain exactly what you're asking - could you be a bit more specific about what you're trying to do?

[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?

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

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

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

[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?)

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