how to change the color of a table cell depending on the numerical value row wise

[9738078959]

KPI | Week1 | Week2 | Week3 | Week4 |
Aging | 42 | 48 | 50 | 60 |
SLA | 0 | 3 | 7 | 2 |

I would like to assign a rule as below
1. "Aging" row to change the colour of a single cell which is below 50 to Green and if it is above 50 to Red.

1. "SLA" row to change the color of a single cell which is below and equal to 2 to Green and if it is equal to 3 to Amber and if it is greater than 3 to be Red

[kamlesh_vaghela]

Hi @9738078959,

You can use custom cell renderer in javascript for your dashboard.

Please check below link for more information.

http://dev.splunk.com/view/webframework-developapps/SP-CAAAEUB

Check below link for example reference.

http://dev.splunk.com/view/webframework-codeexamples/SP-CAAAEVM

Find below code in the link and do appropriate changes as per your logic.

// Use the BaseCellRenderer class to create a custom table cell renderer
            var CustomCellRenderer = TableView.BaseCellRenderer.extend({ 
              .
              .
              .
              .
              .
            });

Let me know for further assistance.

Thanks
Kamlesh

[skoelpin]

I think this is what your looking for

https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Viz/TableFormatsFormatting

[9738078959]

I have two rows in a table and both have two different conditions
For Aging--> below 50 to Green and if it is above 50 to Red.
for SLA --> less than or equal to 2 to Green and if it is equal to 3 to Amber and if it is greater than 3 to be Red

i should change the color of cell based on condition...please help!!

[ddrillic]

It's interesting to see the lovely Format/Color feature only for the Single Value chart -