Exporting hand count associated with each stat into excel

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Exporting hand count associated with each stat into excel

Postby cyberlord » Fri Jan 04, 2019 10:49 am

For every stat in the report, there is a base number (Denominator), using which it was calculated. I have marked this in the image below
pt4_stat_querry.png


What I need to know is :

how do I export this number into excel report
cyberlord
 
Posts: 5
Joined: Wed Jan 25, 2017 5:24 am

Re: Exporting hand count associated with each stat into exce

Postby Flag_Hippo » Fri Jan 04, 2019 2:42 pm

To export the numbers they need to be in the report. For example if you duplicate the existing 'Call PF Squeeze' stat you can change the 'Format Type' to 'Expression:' and use this:

Code: Select all
format('{1} ({2}/{3})', format_number ((cnt_p_squeeze_def_call / cnt_p_squeeze_def_opp) * 100, 2, false, false), format_number(cnt_p_squeeze_def_call, 0, false, false), format_number(cnt_p_squeeze_def_opp, 0, false, false))
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Exporting hand count associated with each stat into exce

Postby cyberlord » Sat Jan 05, 2019 2:32 am

It worked, Thank you.
cyberlord
 
Posts: 5
Joined: Wed Jan 25, 2017 5:24 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 16 guests

cron
highfalutin