how to add dashboard color based on real time % count

ARAVINDA11
Tera Contributor

hello team,

 

can anyone please suggest or help

 

is it possible to add color based on real time % count in the widgets on dashbaord if yes please provide me the steps please

 

ARAVINDA11_0-1783967564795.png

 

2 REPLIES 2

Tanushree Maiti
Tera Patron

Hi @ARAVINDA11 

 

Refer: 

Colors in data visualizations 

How to change the color of widgets in Performance Analytics? 

 

Single Score Widget Color in Platform Analytics 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

Vikram Reddy
Tera Guru

Hi @ARAVINDA11,

 

Looking at your screenshot ("Model % on Hardware Asset", "Manufacturer % on Hardware Asset" and so on) are Performance Analytics Single Score widgets, the sparkline and the "Jul 12: 100%" comparison line under the number is a PA giveaway, plain reports don't render that. Going with that assumption.

 

Postive note,  it's absolutely possible, but the color isn't a setting you flip on the widget itself. It comes from the indicator behind the score. PA colors a score by comparing it against a Target, not by just checking the raw percentage, so the whole thing lives on the pa_indicators record, not the dashboard. Before you go digging for a "color" option on the widget, check these on the indicator instead:

  • The Direction field on the indicator is set to Maximize or Minimize (leave it blank and colors simply won't render, get it backwards and green/red flip on you)
  • The indicator has at least one record in its Targets related list, with a value and an Applies From date that covers today
  • That target's Color Scheme is actually a threshold scheme, either the 3-color or 5-color traffic light, and not left as None
  • If the widget is scoped to a specific breakdown (e.g. by manufacturer), the target is defined against that same breakdown element, not just the overall aggregate
  • The widget isn't overriding this under the gear icon, Style tab, with a fixed color instead of "by score"

Once Direction and a Target with a color scheme are set, the score tile itself should pick up green/amber/red automatically based on how far off target the current percentage is. One thing worth knowing: some users have reported the target line and color render fine on the widget, but the target's numeric value only shows up in Analytics Hub, not on the dashboard view, that appears to be a separate display quirk, not a config issue on your side.

 

If these turn out to be plain Reporting widgets instead of PA (no Performance Analytics license), the coloring works differently, Single Score reports have their own threshold ranges under the Style tab with no Target/Direction concept at all. Let me know which one you're actually on and I can get more specific.

 

Thank you,
Vikram Karety
Octigo Solutions INC