Page 1 of 1

Global player statistics

PostPosted: Fri Dec 19, 2025 9:58 am
by duracell314
Hello everyone,

I have a question on the histogram attached. I think many of us are familiar with it.

I suppose those statistics refer to the result the players achieved globally, against everyone.

Would be great to find a way to analyze how the hero performs agains each category.

Do you know how to do something like that?


Thanks a lot!

Re: Global player statistics

PostPosted: Sat Dec 20, 2025 6:01 am
by Flag_Hippo
There isn't an equivalent report or filter available to display your win/loss by VPIP ranges of villains.

Re: Global player statistics

PostPosted: Mon Dec 22, 2025 11:53 am
by duracell314
Flag_Hippo wrote:There isn't an equivalent report or filter available to display your win/loss by VPIP ranges of villains.

Thanks a lot!

Re: Global player statistics

PostPosted: Tue Dec 23, 2025 9:33 am
by Flag_Hippo
Coming back to this you could review data in a different way with a custom filter if that's helpful:

Code: Select all
cash_hand_player_statistics.flg_hero
AND cash_hand_player_statistics.flg_vpip
AND cash_hand_player_statistics.id_hand IN (
    SELECT chps1.id_hand
    FROM cash_hand_player_statistics chps1
    JOIN cash_hand_player_statistics chps2 ON chps1.id_hand = chps2.id_hand AND chps2.flg_hero
    WHERE NOT chps1.flg_hero
    AND chps1.flg_vpip
    AND (
        (chps1.amt_won < 0 AND chps2.amt_won > 0)
        OR
        (chps1.amt_won > 0 AND chps2.amt_won < 0)
    )
    AND chps1.id_player IN (
        SELECT cc_check.id_player
        FROM cash_hand_player_statistics chps_cc
        JOIN cash_cache cc_check ON chps_cc.id_player = cc_check.id_player
        GROUP BY cc_check.id_player
        HAVING (SUM(cc_check.cnt_vpip) * 1.0) / ((SUM(cc_check.cnt_hands) - SUM(cc_check.cnt_walks)) * 1.0) BETWEEN 0.50 AND 0.75
    )
)

This will filter hands where you and players with a VPIP of 50%-75% both VPIP'd in a hand and won/lost money e.g. you win and the high VPIP players lose or vice versa. Bear in mind that your actual winnings in the hands can still be influenced by other players in multiway pots. You can edit the expression filter for other VPIP ranges. You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

Re: Global player statistics

PostPosted: Wed Dec 31, 2025 1:37 pm
by duracell314
Thanks again Hippo!

That is very interesting! I will have a look.