How to create RAG dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 05:46 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 06:16 AM
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