Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to create RAG dashboard

manukundur
Giga Contributor

Hi All,

I would like to create a dashboard from Project task table . If my planned end date is greater than actual end date, I would like to display red colour in project status field in dashboard.

Is this possible?

How would I implement it.

1 REPLY 1

kevinray
Giga Expert

What type of report are you running? Are you talking about a list report on a dashboard. There are a ton of ways to do this. If you have Performance Analytics, that would be the best.


If your just creating reports and putting them on a dashboard, then I'm assuming you are using a list because you wanted to see a specific field change color under specific conditions.



You need to create a new "Field Style" https://xxx.service-now.com/nav_to.do?uri=/sys_ui_style_list.do


(Replace xxx with your instance name)



Table: project_task (or whatever your table name is)


Field: project_status (or whatever your field name is )


Then your "value" will be something like this (NOTE: UNTESTED and FIELD NAMES NOT ACCURATE):



Value:


javascript:(current.planned_end_date.getGlideObject() > current.actual_end_date.getGlideObject());



Background something like : background-color:tomato