Dashboards & Visualizations

Highlight Highest and Lowest Values in Table With Dynamic Columns

avisram_splunk
Splunk Employee
Splunk Employee

I have a dashboard panel with a statistical table on it. The column labels are date/time values based upon the time range that the user selects for the dashboard. Therefore the column labels are dynamic. I need to highlight the the top 2 values in each column. See the example image - the cells outlined would be highlighted red (highest value) and yellow (2nd highest value). I've check the dashboard examples app and the table cell highlighting example is for a specific column and the highlighting is based on a value falling within a specific range (eg. value>2). This doesn't meet my requirements. Any ideas or suggestions to point me in the right direction would be greatly appreciated. Thanks!

alt text

0 Karma

adonio
Ultra Champion

maybe use heat map function?

alt text

0 Karma

avisram_splunk
Splunk Employee
Splunk Employee

A heatmap won't work because it overlays across the entire table (including the Total column) - so the colour range is based on the values of the entire table as shown. I need per column.
alt text

0 Karma

adonio
Ultra Champion

i think there are couple of examples in the dashboards examples app that answers your use case, https://splunkbase.splunk.com/app/1603/
take a look at the "Table Cell Highlighting" example under "Table Elements"
hope it helps

0 Karma

avisram_splunk
Splunk Employee
Splunk Employee

Thanks for your reply. I looked at that example, however it is based on the column names remaining static. My use case is where the column names are dynamic because they are based on the time range that the user selects. The other difference is that the example looks for values within certain numeric ranges (>2, >1, >0) whereas I need to find the top 2 values in each column.

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 ...