why some stats show times/opportunity and others show ON ()?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 3:09 am

CHECK MINIRAISE /CHECK RAISE

(cnt_f_check_miniraise_HU / cnt_f_check_raise_HU) * 100

FORMAT EXPRESSION
/%.2f
WIDTH
65 (other question: HOW WORKS THIS?)

FORMAT SUMMARY EXPRESSION
nothing here

colummns:
cnt_f_check_raise_HU

sum(if[holdem_hand_player_statistics.flg_f_check_raise and (holdem_hand_summary.cnt_players_f = 2), 1, 0])

cnt_f_check_miniraise_HU

sum(if[holdem_hand_player_statistics.flg_f_check_raise and (holdem_hand_player_detail.amt_f_raise_made = 2 * holdem_hand_player_detail.amt_f_bet_facing) and holdem_hand_player_detail.amt_f_raise_made > 0 and (holdem_hand_summary.cnt_players_f = 2), 1, 0])

FLOP DONK HU
100 * cnt_f_donk_HU / cnt_f_donk_opp_HU

i have tried also to do (without success):

(cnt_f_donk_HU / cnt_f_donk_opp_HU) * 100


FORMAT EXPRESSION
/%.2f
WIDTH
55 (other question: HOW WORKS THIS?)

FORMAT SUMMARY EXPRESSION
nothing here

100 * cnt_f_donk_HU
sum(if[holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.flg_f_bet AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) and (holdem_hand_summary.cnt_players_f = 2),1,0])

100 * cnt_f_donk_HU / cnt_f_donk_opp_HU
sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND (holdem_hand_player_detail.flg_f_open_opp) AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) and (holdem_hand_summary.cnt_players_f = 2) , 1 , 0 ])

THIS WORKS:

ALLIN IP HU

(cnt_f_allin_ip_HU / (cnt_f_bet_ip_HU + cnt_f_raise_ip_HU)) * 100

FORMAT EXPRESSION
/%.2f
WIDTH : 55
Why theese last 2 works and the first 2 no? OBVIOUSLY EACH STAT HAS "SHOW TIMES/OPPORTUINITIES" TRUE but in the first 2 stats the hud shows (), in the last shows the ratio, like i expected
ty
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 3:59 am

sorry i put only 3 stats, so i menat that the first 2 dont work and the last works.
i have tried to put value expression with (......) * 100 WRITING "*100" TO THE END OF THE EXPRESSION, but non succes.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby WhiteRider » Sun Sep 27, 2009 7:11 am

The exact layout of the Value Expression is quite picky about spaces, etc.
Make sure it is exactly:
(x / y) * 100

It looks like you have it correct in the first one but not the second, but of course there could be a difference between what you posted here and what is in the stat.
Change "100 * cnt_f_donk_HU / cnt_f_donk_opp_HU" to:
(cnt_f_donk_HU / cnt_f_donk_opp_HU) * 100

If you still can't get your stats to work correctly please Export and attach them to a Support ticket - you'll need to compress them.
Tutorial: Submitting a Bug Report
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 7:18 am

I HAVE TRIED TO DO IN THIS WAY (FOR THE FIRST STAT), PUTTING THIS STRING IN FORMAT EXPRESSION E SUMMARY EXPRESSION, BUT IT SHOWS ONLY "()"

format( '{1}% ({2}/{3})', format_number ((cnt_f_check_miniraise_HU / cnt_f_check_raise_HU) * 100,0,false,false), cnt_f_check_miniraise_HU, cnt_f_check_raise_HU)
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 7:23 am

i type exactly with form (X / Y) * 100

or ((x + y) / (r + k)) * 100

and in format:

/%.2f

it doesnt work.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 7:56 am

IS NECESSARY UPDATING THE CASH?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby kraada » Sun Sep 27, 2009 8:50 am

Try duplicating a stat that already does work and then editing; sometimes the whitespace can get really finicky. You also need to turn on show times/opportunities once you've added the stat to your HUD in the Statistics Properties window. You don't need to update the cache to have it work but it is recommended as things will slow down considerably without it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Sun Sep 27, 2009 8:52 am

IT WAS A STUPID PROBLEM, I NEED TO RESTART PT3, AFTER TYPING AND SAVING THAT STRING LIKE (x / S) * 100.

HOW CAN I SAY THAT TICKET SENT IS SOLVED?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: why some stats show times/opportunity and others show ON ()?

Postby kraada » Sun Sep 27, 2009 9:22 am

Reply to the ticket saying it's fixed after restarting PT3 and we'll close the ticket. Or you can PM me your ticket number and I'll put a note on it and close it for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: why some stats show times/opportunity and others show ON ()?

Postby marvin » Wed Sep 30, 2009 5:37 am

i replied, but if is necessary, this was the ticket: Support Ticket #70788. TY
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests