gauge data selection

[terrat]

hi

i have a stored procedure that returns 2 items of data. with charts i am able to select which data i want to display. i cannot find this same setting with the gauge. it defaults to the first item.

[JuanC]

If you are using powershell and out-gauge you can do something like this

GetYourData | out-gauge -value {$_.Trials} 

Where Trials is the name of the property/column you are interested in. Note that if your SQL returns multiple rows we will use only the first one.

Unfortunately we do not expose the UI to choose the column for a gauge in the PowerGadgets Creator. Note that you can open a PGF in notepad and add the following inside the <Window> tag for the appropriate gauge

  <Data.PropertyCount>1</Data.PropertyCount>

  <Data.Property0>MainValue</Data.Property0>

  <Data.Property0ScriptBlock>$_.Trials</Data.Property0ScriptBlock>

 JuanC