specify number of players in a hand

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

specify number of players in a hand

Postby Valuelol » Mon Jul 12, 2021 11:31 am

Hi,
I want to show VPIP for when only 6 players are dealt into a hand :
so i changed VPIP : (cnt_vpip / (cnt_hands - cnt_walks)) * 100 to (cnt_vpip_6players / ( cnt_hands_6players - cnt_walks_6players)) * 100

here are the columns:
sum(if[cash_hand_player_statistics.flg_vpip
AND cash_hand_player_statistics.id_player = 6 , 1, 0])

sum(if[cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.id_player = 6, 1, 0])

sum(if[lookup_actions_p.action = ''
AND cash_hand_player_statistics.id_player = 6, 1, 0])

What went wrong?
Valuelol
 
Posts: 10
Joined: Wed Dec 03, 2008 11:58 pm

Re: specify number of players in a hand

Postby Flag_Hippo » Mon Jul 12, 2021 12:12 pm

You should be using cash_hand_summary.cnt_players to specify hands in which 6 players were dealt in.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 14 guests

cron
highfalutin