database analysis

[WhiteRider]

Ah, OK.
If you want to keep the actions/opportunities in the summary line, but lose the unnecessary decimal places, you need to use format_number.
Let's say your format expression is like this:

format( '{1}% ({2}/{3})', (cnt_a / cnt_o) * 100, cnt_a, cnt_b )

To have it display without the decimal places, change it to this:

format( '{1}% ({2}/{3})', (cnt_a / cnt_o) * 100, format_number(cnt_a,0,false,false), format_number(cnt_b,0,false,false) )

I'm not sure why that is necessary in the summary expression, but it should help.
If you want to remove the actions/opportunities altogether just change the format type of the summary expression to 'Number'.

[SarahSugar]

Hey Guys,

I want to analyse my own statistics.

1. How do I get my own UTG, MP, CO, BU, SB Openraise into the stats report?
2. How do I get my own 4bet success in the report?

Can I see steal success from a) co , button, sb seperate?

Cheers

[SarahSugar]

On a side note: my hud stopped displaying the hands abbreviated.
although I tried adding hands k and hands abbreviated, it shows the hands in full, what am I missing?

I managed to crash the hud by setting decimals to -2 *proud ^^

[kraada]

You want to use any report grouped by Position - for example, choosing Summary and then the Position drop down will show you what you want to see. You can then add any stat to that report by right clicking it and choosing to configure the report - you can add steal success there and it will be split by position. We don't have a built in 4bet success though we do have a built in 3bet success that you could add. I can look into building a 4bet success for you and putting it in our warehouse but it may take me a little bit.

The issue with Hands Abbreviated is known and should be fixed in the next beta version.

Did the crash reporter appear after your crash?

[SarahSugar]

Thanks a lot, the 4bet success would be really important.

I am 90% confident that no crash report came up after the hud crashed.
I found the report settings, cheers.

[SarahSugar]

Hey Guys,

How do I get my report to tell me the winrate for: Hero 3bets , villains calls preflop -> no allin preflop happened

[kraada]

Use the filters:

Actions and Opportunities -> Preflop -> Raises -> 3Bet Preflop

and

Actions and Opportunities -> Flop -> Actions Sequence -> First Action Any Action

and

Actions and Opportunities -> Preflop -> Opportunities -> 5Bet+ Opportunity

and then use Not Selected on the last one so it's NOT (5Bet+ Opportunity) - then you made a 3bet, didn't face a 4bet or higher (because you couldn't make a 5bet or higher) and weren't all in because you took some flop action.

[SarahSugar]

Cheers,

How do I filter for:
Went to showdown FALSE
Won Hand False... I get won hand... but cant do: no SD...

Also will there be a money won without SD stat soon?

[WhiteRider]

Add the "saw showdown" filter and then on the Current/Active Filters page select it and click 'NOT' Selected at the bottom.

I will let kraada comment on the money won without SD stat - I'm not sure whether that was omitted deliberately, but it can certainly be built as a custom stat.
Would you want to see amount of money won without showdown, or the percentage of hands you won when you didn't go to showdown?

[SarahSugar]

Mmount of money won without showdown would be great.
the percentage is already build in imho and a good tool to compare you to other players