Convert to hand stat

[Tinman9956]

Is it possible to convert this player stat into a hand stat, if possible colud you show me how. Thanks

[Tinman9956]

Or is it possible to modify this stat to add the ave all in as a summary total at the bottom of the colunm. Thanks

[Flag_Hippo]

That's the same thing as you asked here - are you having trouble with that?

[Tinman9956]

Yes I cound not figure out how to get a summary total at the bottom of the column and get the % to show correctly. I though it might be easier to just convert the stat to a hand stat and then figure out how to show the ave all-in total and % at the bottom of the column. Sorry about the duplicate thread, Any help appretiated.

[Flag_Hippo]

You were nearly there in the earlier thread but I have attached the stat here for you:

[Tinman9956]

Thank you for taking the time to help me. I downloaded the stat and addded it to my report. Is the total ave right? I have my last 25 hands in the report and 5 all in hands, the total all in average does not seem right, but I'm no math wiz. Thanks again.

[Flag_Hippo]

You are summing the results (72.33 + 46.43 + 36.70 + 35.30 + 29.45 = 220.21) so are you sure you are using the right statistic? Have you changed anything in the statistic I attached? Also note that you will not get the correct average if there are hands in the report that do not have any all-in equity so you will need to filter out those hands.

[Tinman9956]

No change made to the stat you gave me. Here is a sample of hands from a report of all in hands with equ of 25% or less. And a screen shot of the stat I downloaded.

[Flag_Hippo]

I also asked if you were sure that you were using the right statistic in your report and in your screenshot there are two other custom statistics called 'All-In Equity (Copy)' and 'All-In Equity (Summary Avg) (Copy)'. Please remove the existing statistic from the report and then make sure you are adding the 'All-In Equity (Summary Avg)' statistic. If that doesn't help then check the 'val_allin_equity_copy' column and make sure that the 'Summary Type:' is set to 'Average'.

[Tinman9956]

Thank you for all your help ,it was the column setting, works great, thanks again.