topic Re: Single Value Button going to red/amber/green based on dynamic threshold value in Dashboards & Visualizations

Single Value Button going to red/amber/green based on dynamic threshold value

adityapavan18 — Fri, 21 Jun 2013 10:16:47 GMT

I have a scenario where i have to put a single value button showing a avg response time that would go red/amber/green on going on/off a threshold.

This is easy and can be done using range if there is a constant threshold value.

Now in my scenario, the threshold value is not constant and needs to be changed with time, and the single value button will go red/amber/green based on the threshhold value at that point of time.

How do i specify threshold based on time?

Can this be done in splunk dashboards.Please suggest

Re: Single Value Button going to red/amber/green based on dynamic threshold value

linu1988 — Fri, 21 Jun 2013 10:36:08 GMT

Please use the application.css and .js file to acheive the goal. Have a column where it shows normal/warning/critical using eval statement.

In my case i am using .SimpleResultsTable module where i will do exchange for image for a value.

App.css:
.SimpleResultsTable td.Normal {
background-image: url(images/normal.gif/png); [depends on browser]
background-repeat:no-repeat;
background-position:5px 3px;
}

.js file:

onResultsRendered: function() {
this.forEachCellInColumn("State", function(tdElement) {
if (tdElement.text()=="Started") {
tdElement.text("").addClass("Normal");
} else {
tdElement.text("").addClass("Warning");
}
});
}
Add these codes, which will work on a dashboard.

Re: Single Value Button going to red/amber/green based on dynamic threshold value

adityapavan18 — Fri, 21 Jun 2013 11:04:19 GMT

Thnks. But could you elaborate/explain the solution u gave.

Re: Single Value Button going to red/amber/green based on dynamic threshold value

linu1988 — Fri, 21 Jun 2013 11:25:39 GMT

if you do a simple view on a dashboard, you will be able to use "simpleresultstable" module for displaying your eval field value. So i am not sure which i should explain? The .js file will replace the value with image on the go.

Re: Single Value Button going to red/amber/green based on dynamic threshold value

adityapavan18 — Fri, 21 Jun 2013 13:59:29 GMT

My doubt is that i dont have a constant threshold value.The threshold value changes with time? how do you factor that into that?? example at 9:00 AM the threshold value is 3 it will go to amber at 120% of 3 and red at 150%3 ..where the i need the threshold to be changed to 5 at 11:00 AM now the amber state with will more than 120% of 5 and so ..

Re: Single Value Button going to red/amber/green based on dynamic threshold value

linu1988 — Mon, 28 Sep 2020 14:09:00 GMT

It depends what is your requirements are like! If your threshold values are varying with time, create a lookup / using eval statement find the exact threshold value for that Hour. I will give an example

eval threshold=case(date_hour =9 threshold, "3", date_hour =11, "5")|eval State=case(value <= threshold, "Normal", value >= threshold*1.2, "warning", value >= threshold*1.5, "Critical")|Table State

then as i mentioned above replace the codes and place a image with relevant color to appserver/static/images folder. it will do the job what you want

Re: Single Value Button going to red/amber/green based on dynamic threshold value

adityapavan18 — Mon, 24 Jun 2013 07:09:10 GMT

Thnx a lot. Look-up way should do the trick thnx

Re: Single Value Button going to red/amber/green based on dynamic threshold value

santosh_hb — Fri, 02 May 2014 09:10:22 GMT

Hi, I am a newbie in Splunk. Currently, I am also working on the same issue as above i.e. the threshold value is dynamic and keeps changing with time. I need to display red, green and amber based on the threshold value. i.e. if the latency is 20% of threshold then red icon should be displayed, if the latency is 50% of threshold then green icon should be displayed and if the latency is 120% of threshold then amber icon should be displayed.
As, I am new to .css and .js, I am unable to understand the above code. Can anyone please share the entire code (i.e. xml code, .css and .js code). It will be of much help for me.
Currently, I have created a sample .csv file that contains the following fields:
Ex: data_hour (1/1/13 8:00 AM), Latency (secs): 1.25, Threshold: 1
Thanks in advance.