How to color column in report?

[Dawid2]

Hello All,

I'm trying to run following report against SLA:

What I'm trying to accomplish is: I want Actual Time Left column to be highlighted in red every time value in this column is 30 minutes or less. I tried creating new chart color for Task SLA, Actual Time Left column and value I pasted was <30 minutes, <1800 but it's still not working.

I'd like to make a gauge on the homepage for this, to highlight INCs with Actual time left less or equal to 30 minutes in red.

Is it something I can accomplish?

Thank you!

Best,

Dawid

[mike_bush]

You need to create a Field Style for the Actual Time Left field where the VALUE field uses javascript:current.time_left.dateNumericValue() to get the number of seconds.

eg javascript:current.time_left.dateNumericValue() < 1800

[Goran WitchDoc]

I think report range will help you here. Also there is under reports "chart colors", but this is for a specific field. Report ranges does exactly what you want.

I have posted about it here:

Is it possible to set specific colors to pie chart based on a percentage ranges of a field