Dashboards & Visualizations

How to add color to cells based on condition?

smruti13
Observer

Hi,

I have a table as below:

Team Points/week Sprint 1 Sprint 2 Sprint 3 Sprint 4 Sprint 5 Sprint 6

A 18 2 9 3 0 5 5

B 38 16 28.5 0 26 10 8

I need to add color to the sprint fields as per the below condition:

sprint points>=points/week : GREEN
sprint points<90% ponts/week : RED
sprint points>=90% and <100% : AMBER

eg. Sprint1=2 points/week=18, hence color=RED(less than 90%)

Can someone help me achieve this?

0 Karma

jeffland
SplunkTrust
SplunkTrust

You are probably looking for this.

0 Karma

niketn
Legend

@smruti13, if you are on Splunk 6.5 or higher this should be built in to Splunk. Refer to Table Formats example in Splunk 6.x Dashboard Examples App.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

smruti13
Observer

Thanks @niketnilay . But I am using splunk 6.4 and I think this can be achieved using javascript. Any idea on that?

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...