ericb1
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by ericb1
-
-
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!
2 values in a gague chart?
in PowerGadgets Support
Posted
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!