Spin and go multiplier count

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Spin and go multiplier count

Postby 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

Re: Spin and go multiplier count

Postby 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

Re: Spin and go multiplier count

Postby 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

Re: Spin and go multiplier count

Postby 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

Re: Spin and go multiplier count

Postby 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

Re: Spin and go multiplier count

Postby Pyr00 » Thu Jun 27, 2019 2:46 pm

I want to create or edit the custom stat multipler and remove X2 and X4 and only get X6+ but i dont know how. This is the stat.

https://gyazo.com/2849c4d38d21ef8c54edf25160d9a89b
https://gyazo.com/6b85ea49cd7b0509ebac700ad3825c4f
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Spin and go multiplier count

Postby 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

Who is online

Users browsing this forum: No registered users and 19 guests

cron