Jump to content
Software FX Community

2 values in a gague chart?


ericb1
 Share

Recommended Posts

Sorry for the newbie question, I'm trying to get up to speed with Power Gadgets.  I've got a thermometer gague, with the data coming from my sql server.

 The documentation says to return only a single variable, but my sql returns 2 variables:  an actual value and a goal value.  So I would like to have my "goal" value as the maximum value and my "actual" value as the indicator.  So that when it refreshes, the actual value will keep increasing towards the top of the thermometer, which is the goal.

Any help is greatly appreciated, thanks!

Link to comment
Share on other sites

You may not be able to provide the SQL script, but can you show how the values are retunrned?  Just simply copy and paste how the values are outputted, and possibly add this to the end of your PowerShell command or script "|get-member".

Using get-member allows me to see what kind of object is outputted.  It is possibly a string, but could also be some kind of SMO object (Sql server Management Object).

Marco

Link to comment
Share on other sites

thanks so much for the help.  My resulting sql looks like this:

Total 94561 7855

One row with 2 or 3 columns.  I can change it around though if needed. 

So I'm trying to get the top of the gague to be 94,561, and the filler part to only read 7,855.  The goal of 94,561 is a monthly goal and onlu changes at the beginning of every month.  The "actual" number of 7,855 increases steadily throughout the month as we try to reach our goal.

 My script looks like this:

SELECT

'Total',(SELECT SUM(totalprocessed) FROM vw_total_numbers_0

WHERE RIGHT(trust,4) = 'goal') AS 'Total Goal',(SELECT SUM(totalprocessed) FROM vw_total_numbers_0

WHERE RIGHT(trust,4) <> 'goal') AS 'Actual'

 

Thanks again!

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...