Page 1 of 1
Stats with no sample
Posted:
Thu Nov 15, 2012 7:29 am
by husngforfood
I can't figure out why some stats display a "0" when there is no sample. All the built in stats display "-", but some of my custom stats display "0". What might be the reason for this?
Re: Stats with no sample
Posted:
Thu Nov 15, 2012 7:47 am
by husngforfood
Figured it out.
I have a stat: (x/y)*7 - how can I make this stat display "-" when there is no sample? I use if(y=0, '-', (x/y)*7) but maybe there's an easier way?
Re: Stats with no sample
Posted:
Thu Nov 15, 2012 9:16 am
by kraada
The times and opportunities are only recognized when a stat is in the exact form:
(A / B) * 100
Since yours doesn't match that form, we treat it just as a mathematical construction of a single number.
The only way I can see to transform your stat into one that does it would be to make it:
((x * 7) / (y * 100)) * 100
Then you'll see times and opportunities, just the opportunities are multiplied by 100 and the times by 7. It'll give you your n/a though.
Re: Stats with no sample
Posted:
Fri Nov 16, 2012 8:45 am
by husngforfood
Thanks for a good pointer.
Re: Stats with no sample
Posted:
Mon Nov 19, 2012 5:07 am
by husngforfood
Is there a way to use 'if' in Value Expression and still get the flyover popup to display 'times/ opportunities'?
Are there any options to edit the flyover popups? Any clever tips & tricks maybe?
Re: Stats with no sample
Posted:
Mon Nov 19, 2012 10:53 am
by kraada
The tooltips are not editable. You could use if() statements to show times and opportunities in a bit of a clunky way, originally described in
this post. It was written for PT3 but works just as well for PT4.
Re: Stats with no sample
Posted:
Mon Nov 19, 2012 4:27 pm
by husngforfood
Double post
Re: Stats with no sample
Posted:
Mon Nov 19, 2012 4:28 pm
by husngforfood
I want to achieve a situation where the stat on table would display a result of a formula like 'x' but the tool-tip would show 'x (y/z)' like in case of a percentage stat. Your example changes the on table stat as well if I understand correctly.
Re: Stats with no sample
Posted:
Tue Nov 20, 2012 11:48 am
by kraada
I'm pretty sure if you leave the value expression in the (x / y) * 100 form you should still get times and opportunities in the tooltip regardless of what you have set for the format expression.
Re: Stats with no sample
Posted:
Thu Nov 22, 2012 4:40 am
by husngforfood
Yeah, that worked. Thanks!