Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by dajg » Mon Apr 15, 2019 11:21 am
I am trying to create a percentage for each multiplier in a spin and go report.
I downloaded he multiplier stat from the custom stat repository and used it to try and create this column to count the number of x2 multipliers:
sum(if[(amt_prize_pool / amt_buyin_fee)=2,1,0])
This validates fine but when I try to use the stat it say an invalid expression is being used. I did get a longer error message the first time I saved it but since closing and reopening PT4 I no longer get this. It was something about it not being a valid SQL expression or similar.
Help!
-
dajg
-
- Posts: 17
- Joined: Wed Dec 02, 2009 2:16 pm
by KAIOU » Mon Apr 15, 2019 11:21 pm
On 2+2 there is a free software that let you count every spin multiplier you got !
-
KAIOU
-
- Posts: 72
- Joined: Sat Mar 09, 2019 10:37 pm
by Flag_Hippo » Tue Apr 16, 2019 7:27 am
- Code: Select all
sum(if[(tourney_summary.amt_prize_pool / (tourney_summary.amt_buyin + tourney_summary.amt_fee)) = 2, 1, 0])
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by Pyr00 » Wed Jun 26, 2019 5:46 pm
How can i make a custom stat for multipers x6+ only ?
-
Pyr00
-
- Posts: 34
- Joined: Sun Mar 19, 2017 12:42 pm
by Flag_Hippo » Thu Jun 27, 2019 2:26 pm
What type of statistic do you want and where you want to use it? In most reports you can just add the multiplier stat from the
Download Warehouse which will break up the statistics into a line for each level of multiplier.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by Flag_Hippo » Fri Jun 28, 2019 7:25 am
I don't know about that but you can filter for that with this expression filter in a custom report:
- Code: Select all
(tourney_summary.amt_prize_pool / (tourney_summary.amt_buyin + tourney_summary.amt_fee)) = 6
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 19 guests