How to count spins of a specific multiplier

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

How to count spins of a specific multiplier

Postby dryas » Fri Nov 20, 2020 8:29 am

Hello,

I'm trying to get in a report the number of spins of a specific multiplier for a session.
I can get the multiplier as a selector adding the following stat in the report:
Code: Select all
amt_prize_pool / amt_buyin_fee

But what i whant to get is the number of x2, x3, x5, and so on for a specific date.

Any idea on how to tackle that ?
dryas
 
Posts: 43
Joined: Mon Sep 02, 2013 9:07 am

Re: How to count spins of a specific multiplier

Postby majonyjony » Fri Nov 20, 2020 5:16 pm

You can download stat "multiplier" in Download Warehouse.
https://www.pokertracker.com/custom/stats
majonyjony
 
Posts: 106
Joined: Wed Oct 08, 2008 4:01 am

Re: How to count spins of a specific multiplier

Postby dryas » Sat Nov 21, 2020 9:46 am

majonyjony wrote:You can download stat "multiplier" in Download Warehouse.
https://www.pokertracker.com/custom/stats

This stat is the one i give in the OP.

What i want to achieve is to have a report that for each date specify how many x2, x3, ... i have on one line (and not a line per multiplier). It seems I can't achieve that with the multiplier stat
dryas
 
Posts: 43
Joined: Mon Sep 02, 2013 9:07 am

Re: How to count spins of a specific multiplier

Postby Flag_Hippo » Sun Nov 22, 2020 7:03 am

You are going to need separate custom statistics that count the numbers of each multiplier and then add each of them to your report. For a 2x multiplier the column expression would be:

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: How to count spins of a specific multiplier

Postby dryas » Sun Nov 22, 2020 5:48 pm

thank you
dryas
 
Posts: 43
Joined: Mon Sep 02, 2013 9:07 am

Re: How to count spins of a specific multiplier

Postby doppiosei83 » Thu Jul 13, 2023 4:47 pm

Hi, can you help me with this? I would also like a single row in the reports, telling me how many spin for each multiplier..... but I don't know anything about sql, I'm not good with English, and I can't use the expression filter..... if I copy this it tells me invalid expression...
Can you help me? Thanks
doppiosei83
 
Posts: 10
Joined: Tue Jul 26, 2011 5:02 pm

Re: How to count spins of a specific multiplier

Postby Flag_Hippo » Fri Jul 14, 2023 6:33 am

doppiosei83 wrote:if I copy this it tells me invalid expression...

That sounds like you are using the expression in a statistics value expression instead of using it to create a column expression (which is then used to create the statistic) - see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: How to count spins of a specific multiplier

Postby doppiosei83 » Tue Jul 18, 2023 9:18 pm

Hi Hippo, I didn't understand much about it, but trying to meet my needs I built a small report as I liked.
I am attaching a screenshot

Now the only thing I would like to add is a custom statistic, showing me the frequency of multiplier output on my total tournaments.
Example, from my screenshot :

x2 194 out of 409 = 47.43%
x3 174 out of 409 = 42.54%.
x4 22 out of 409 = 5.37%
x5 14 out of 409 = 3.42%
x10 5 out of 409 = 1.22%.

How do I create this statistic that I manually calculated above? Basically it has to consider all the tournaments played and calculate the % compared to the multiplier that came out...

Can i help me step by step?

Translated with www.DeepL.com/Translator (free version)
Attachments
2023-07-19 03_04_02-PokerTracker v4.17.5 - Database_ PT4_2023_02_16_171019.jpg
doppiosei83
 
Posts: 10
Joined: Tue Jul 26, 2011 5:02 pm

Re: How to count spins of a specific multiplier

Postby Flag_Hippo » Wed Jul 19, 2023 4:57 am

To do that you are still going to have to create a different report using separate custom statistics for each multiplier. Start by going to 'Configure -> Statistics -> Columns' and creating new custom columns for each multiplier. For example:

cnt_multiplier_x
Code: Select all
sum(if[(tourney_summary.amt_prize_pool / (tourney_summary.amt_buyin + tourney_summary.amt_fee)) = x, 1, 0])

where 'x' is the multiplier.
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 27 guests

cron