Dashboards & Visualizations
Highlighted

Changing the colour of a table cell depending on the numerical value

Contributor

Hi Splunkers,

I have a simpleResultsTable module on an Advanced XML Dashboard that looks like this:


Users | User 1 | User 2 | User 3 | User 4 | User 5 | User 6 | User 7 |
Success % | 100% | 100% | 89% | 100% | 92% | 100% | 100% |
Fail % | 0% | 0% | 11% | 0% | 0% | 0% | 0% |

It is linked to a saved search which runs every hour. As you can see, "User 3" has a "Success %" of 89% and "User 5 has a "Success %" of 92%. I would like to assign a rule to the "Success %" row to change the colour of a single cell which is below 90% to red and a cell between 90%-95% to amber, while leaving the others above 95% as green.

Is there an easy way of implementing this?
Possibly an app, or coding Javascript?

Many thanks!

0 Karma
Highlighted

Re: Changing the colour of a table cell depending on the numerical value

Champion

Yes it is possible. There is an app called rowcolorizer. It mostly a POC app, but it will get you most of the way there.

0 Karma
Highlighted

Re: Changing the colour of a table cell depending on the numerical value

New Member

getting error message like "This app is currently not available..."
Any suggestions please...

0 Karma