Dashboards & Visualizations
Highlighted

How to color code cells based on range of another field?

Communicator

Hi, please consider this example panel within my dashboard:

ticketID    due_date   days_remaining
ticket1    07/20/2019      19
ticket2    08/20/2019      49
ticket3    09/20/2019      79

I know I can color the days_remaining field using the UI, but my quesition is: how do I color cells under due_date based on the range the corresponding days_remainingfield values are within? The range conditions are 0-30 is red, 31-60 is yellow, and 61-90 is green.

With the example panel above, 07/20/2019 should be red, 08/20/2019 should be yellow, and 09/20/2019 should be green.

Note: I'm a Power User at work so I don't have access to .conf files. Can I achieve my solution using xml? Or maybe JavaScript (if I even have access).

0 Karma
Highlighted

Re: How to color code cells based on range of another field?

Champion
0 Karma
Highlighted

Re: How to color code cells based on range of another field?

Communicator

Hi, both of your provided links require that I have access to Splunk directories. As mentioned in my initial post, I'm only a Power User. I don't have access to Splunk directories unfortunately.

0 Karma