Color coded report based on incident priority?

[mehershanti]

Hello,

I need to build a report based on the priority of the open security incidents.

Lets say the highest priority of the current open incidents is critical, the report should show critical in red color. Or a red block.

if its only one or two high incidents, it should show an amber block or HIGH in amber color. More than 2 high inc should be red again.

else it should show a green block or just medium or low .. whatever is the highest open incident' priority.

I tried heatmaps, but that has more than one breakdown, here the biz wants see only the highest priority - critical or high or medium.

Any ideas?

Thanks much!
Meher.

[Thameem Ansari]

Hello there,

If the requirement is still pending. please share the screenshot of your report to proceed further.

Kind Regards,

Thameem

[mehershanti]

Hello,

For example, consider the below single score PA widgets:

I am able to get the score to be depicted in a color (red amber green) based on thresholds and color schemes and ranges. 

However, the customer wants to see the full widget in the same color (Red green or amber) and not just the number. Something like this:

If coloring the whole widget is not possible, they at least want to see the widget title or border in the red amber green code, dynamically, as per the score.

Regards,
Meher.

[Thameem Ansari]

Hello Meher,

I know it's too late to say this. As of now in ServiceNow it not possible to change the background of the widget. By using the target colour scheme we can only change the counts color which you already achieved. 

But there is one way to achieve it. But I won't recommend doing that as it's not a best practice and a very complex process. Anyway, I'll mention it.

in order to achieve this, you need to create a UI page and render the UI page through a system widget.

and add that system widget to your dashboard.

from that UI page you can do DOM Manipulation as per your requirement. as each PA widget's HTML code will have an attribute called widget which will be the sys_ID of the PA widget you added. using that as a CSS selector you can do the DOM Manipulation to achieve. but still, it's not recommended.

Please mark it as Correct/Helpful If my answer is helpful in any way,

Best regards,

Thameem