problems with summery of a statistic in report

[Finbar Saunders]

Hi,

I am trying to run a report to analyse 'EV Allin Equity' against 'Actual Hand Outcomes' for a large sample of pre-flop all-in hands. The analysis requires that all hands are considered to have equal value (and not valued by BB or pot size). Details are:

Section:
Holdem Tournament Hand

Filters:
Filter on active player - UNCHECKED
Facing all-in CALLED
With 2 players at the flop

Report Stats (non-custom):
Hand#
Player
Site Icon
Hole 1
Hole 2
Winner
EV Allin Equity

I have built three custom stats as well:

1) 'Won=tick'...................... definition: flg_won_hand.................... format: format_bool( flg_won_hand ,'check')

This has worked fine but what I really want to do is sum the number of boxes that are ticked - I couldn't find a way to do this so I tried:

2) 'Won=1'......................... definition: if(str_winner=str_player,1,0)

This worked as well, giving a value of 1 for every hand won and zero for every hand lost, but the summary output was also 1 and I couldn't find a way to add so I tried:

3) 'Won=one'...................... definition: if(str_winner=str_player,output_equals_1,0)

where I built a new variable 'output_equals_1'... where the expression was simply the number '1' but I was able to change the summary type to 'sum'. However, this seems to have summed every hand (it has counted the lost hands as well) and the summary is equal to the total number of hands!

Is there a way that I can have the summary 'add up' all the won hands?

Many thanks for your help.

[WhiteRider]

Duplicate the "flg_won_hand" column and change the Summary Type to "Sum", and use that in your stat.
In the Format Expression of your stat you can use a simple number format like "/%.0f", or something like:
format( 'Won {1} Hands', format_number(flg_won_hand2,0,false,false) )

(Since you're only displaying a checkbox - your #1 solution is the same as I use - I suspect that you'll only want to display the number so /%.0f is probably best.)

[Finbar Saunders]

Thanks for this - problem solved!

I'd recommend PT to anyone based on the quality of the support

[WhiteRider]

You're welcome! We try..

[Finbar Saunders]

I'd like to add another filter to the report but I'm having a bit of difficulty:

I'd like to filter by 'EV Allin Equity > 50' (and also 'EV Allin Equity < 50') in order to analyse the hands based on whether the player went in 'ahead' or 'behind'.

Is this possible?

Thanks

[WhiteRider]

You can't filter on EV currently because the information isn't stored in the database (it is calculated on the fly).
There are plans to change this and at that point you'll be able to do what you want, but I don't yet know when that will be.

For now you can add EV to your report and sort by it to get all the "ahead" hands first, for instance.

[Finbar Saunders]

I did this and export the results to excel where they were easily managed - thanks!

Have finished the analysis and the results have been published at http://www.onlinepokerwatchdog.com

The excellent support at poker tracker has been mentioned on the analysis page...

http://www.onlinepokerwatchdog.com/html/analysis.html

Thanks again!

[WhiteRider]

Thanks