Dashboards & Visualizations

Color a table cell based on value of another table cell in Simple XML

barunbiswas
New Member

I have a table with different columns like:
c1, c2, c3

I would like to color the cell column c3 depending of the value in the cells c1.
(I am able to color the cell C1 depending on the value of that cell)

Could you please let me know how it can be done using Simple XML dashboard.

0 Karma

niketn
Legend

@barunbiswas @qq1248137469 you would need to merge the cells together using SPL. Then

1) Either color merged cell, using expression colorPallete (which use Simple XML only but will still show both cell values in merged cell).
2) Use Simple XML JS extension to parse each cell and split the values. Then apply color based on one value and display the other value.

Both approaches have been explained in following answer: https://answers.splunk.com/answers/686288/how-do-you-highlight-a-table-cell-based-on-a-field.html

Please try out and confirm!

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

neelamsantosh
Path Finder

Select the "art brush" on the table cell header --> select color--> values--> define rules and provide "Cell value is" add the rule. ][1]

0 Karma

qq1248137469
New Member

I downvoted this post because no

0 Karma

niketn
Legend

@qq1248137469 , Downvoting should only be reserved for suggestions/solutions that could be potentially harmful for a Splunk environment or goes completely against known best practices. Simply commenting with constructive feedback on the post you are concerned with will be more beneficial for the community to learn from.

Some of the most active members in Answers have helped set the standard of how voting etiquette should work in the Splunk community which distinguishes our culture apart from other Q&A forums. Upvote early and often to give credit where it’s due for high quality posts, comment where you think feedback needs to be given, and only downvote if something potentially dangerous is suggested or people are just being inappropriate.

If you’re interested in seeing how this voting etiquette was developed, check out this Splunk Answers post: https://answers.splunk.com/answers/244111/proper-etiquette-and-timing-for-voting-here-on-ans.htmlon-...

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...