Profile Picture

How can I set color of pointer in Sharepoint Gauge

Posted By Steve Murray 2 Years Ago
Author
Message
Steve Murray
Question Posted 2 Years Ago
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: Last Year
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 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)Supreme Being (3,490 reputation)

Group: Moderators
Last Active: Last Week
Posts: 2,673, Visits: 2,555
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