Tooltip formatting?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Tooltip formatting?

Postby JustAnotherForum » Sun Jun 07, 2009 6:42 am

I have a custom % stat in my hud. But when I hover over it, the tool tip doesn't give me (attempts/opportunities) like the other stock stats. How do I format this?
JustAnotherForum
 
Posts: 19
Joined: Sun Aug 10, 2008 1:13 pm

Re: Tooltip formatting?

Postby WhiteRider » Sun Jun 07, 2009 9:01 am

It's probably because your Value Expression isn't laid out quite right - it can be a bit picky.
Make sure it looks like this:
(a / b) * 100

If you can't get it to work correctly export your stat and attach it to a Support ticket and someone will take a look at it for you.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tooltip formatting?

Postby JustAnotherForum » Sun Jun 07, 2009 2:09 pm

VP$IP from the BB (Didn't fold facing a raise):

(1-(cnt_bb_steal_fold / cnt_steal_def_opp_bb)) * 100




edit:
would this be better?:
((cnt_steal_def_opp_bb-cnt_bb_steal_fold )/ cnt_steal_def_opp_bb) * 100
JustAnotherForum
 
Posts: 19
Joined: Sun Aug 10, 2008 1:13 pm

Re: Tooltip formatting?

Postby WhiteRider » Sun Jun 07, 2009 3:19 pm

It shouldn't really make any difference, but give it a go.
If it doesn't work, attach it to a support ticket.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tooltip formatting?

Postby pasita » Thu Jun 10, 2010 11:19 am

Did this ever get solved? Some of my custom stats (built on custom columns) work fine ( shows attempts/opportunities), some don't.
Got the exact same formatting as suggested below.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: Tooltip formatting?

Postby kraada » Thu Jun 10, 2010 1:30 pm

I haven't had an update on this sort of issue in quite a while. If you attach the stat that's not working to a support ticket though we'll make sure to look into it for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tooltip formatting?

Postby pasita » Fri Jun 11, 2010 11:51 am

I had a very basic custom stat, (cnt_action / cnt_action_opp) * 100 which worked fine. Then I tried to reverse the percentage doing (1-(cnt_action / cnt_action_opp)) * 100 and also ((cnt_action_opp - cnt_action) / cnt_action_opp) * 100 and the times/opportunity tooltip was lost (also same effect in a report window using this stat). Most other stats still were fine. Going back to original (cnt_action / cnt_action_opp) * 100 didn't help, no opportunity count.

I did a complete housekeeping including reindex and rebuild cache, and the tooltip came back to life. Same for another stats that were missing the opportunity count.

I case you have a nice small test database handy you might want to investigate this... unfortunately I can't keep housekeeping my largish DP to debug further. What I can say for sure though is that it wasn't about the stat per se as the housekeeping fixed things without changing the stat.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: Tooltip formatting?

Postby kraada » Fri Jun 11, 2010 12:46 pm

That's good to know, thanks for the update.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tooltip formatting?

Postby pasita » Sat Jun 12, 2010 2:41 pm

Oops. All of the above is correct other than the reference to another stat. I still have stats that don't show the time/opp, whether in HUD or report.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: Tooltip formatting?

Postby pasita » Sat Jun 12, 2010 2:57 pm

I swear the stats were ok yesterday, they just stopped working.

I now looked at one of those that failed today (let's call this stat A) and removed some white space from the value expression. Rerun report, worked.
Tried to fix stat B, rerun report. Not working. Neither is stat A.
Changed the report a bit, saved, rerun. Stat A and B work fine.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests