Profile Picture

How can I set color of pointer in Sharepoint Gauge

Posted By Steve Murray Last Year
Author
Message
Steve Murray
Question Posted Last Year
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
I am using the following code in the pointer to determine the position of the pointer.  Can I also set the color of the pointer based on a text value in this expression? 
Example:=If(FIRST(Fields!HIL)="Caution",10,IF(FIRST(Fields!HIL)="Extreme Caution",30,IF(FIRST(Fields!HIL)="Danger",50,IF(FIRST(Fields!HIL)="Extreme Danger",70,IF(FIRST(Fields!HIL)="Stop Working",90,0))

The above code works fine for setting the pointer correctly on the gauge.  Can I also set the color of the pointer depending on Fields!HIL= Status?

Thanks in advance
...Steve


Nevron Support Team
Posted Last Year
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 2 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Steve, you can achieve your requirement either by using custom code, or by using expression for the pointer appearance.

Solution with expressions: Simple State Custom Gauge
Take a look at the Pointers -> Appearance tab. The Fill Style of the pointer is specified with the following expression:
=IF(TONUM(Params!GaugeValue.STR) =0, "#868689", IF(TONUM(Params!GaugeValue.STR) <=20, "#E32119", IF(TONUM(Params!GaugeValue.STR) <=40, "#F08A00", IF(TONUM(Params!GaugeValue.STR) <=60, "#FDC844", IF(TONUM(Params!GaugeValue.STR) <=80,  "#89BA17", "#007770")))))

Hopefully this helps.


Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic