Page 1 of 1

Spin and go multiplier count

PostPosted: Mon Apr 15, 2019 11:21 am
by dajg
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!

Re: Spin and go multiplier count

PostPosted: Mon Apr 15, 2019 11:21 pm
by KAIOU
On 2+2 there is a free software that let you count every spin multiplier you got !

Re: Spin and go multiplier count

PostPosted: Tue Apr 16, 2019 7:27 am
by Flag_Hippo
Code: Select all
sum(if[(tourney_summary.amt_prize_pool / (tourney_summary.amt_buyin + tourney_summary.amt_fee)) = 2, 1, 0])

Re: Spin and go multiplier count

PostPosted: Wed Jun 26, 2019 5:46 pm
by Pyr00
How can i make a custom stat for multipers x6+ only ?

Re: Spin and go multiplier count

PostPosted: Thu Jun 27, 2019 2:26 pm
by Flag_Hippo
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.

Re: Spin and go multiplier count

PostPosted: Thu Jun 27, 2019 2:46 pm
by Pyr00
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

Re: Spin and go multiplier count

PostPosted: Fri Jun 28, 2019 7:25 am
by Flag_Hippo
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

highfalutin