Dear community, I have this:
index=*** sourcetype="*********** " Path=*******"
| stats count by HTTPStatusCode. which will display codes 2**,4**, 5**
then I used this code to calculate the failure rate
index=***** sourcetype="*****" Path="*****"
| stats count AS Total count(eval(HTTPStatusCode="200")) as Success
| eval Failure = Total - Success | eval Percent_Failure = round((Failure/Total)*100)."%"
| stats count by Percent_Failure
as you can see above it worked fine showing 2% fail rate. so I added it to my "Classic Dashboard" as a SingleValue and all is good. but, to my frustration, when add it to my new Dashboard Studio. it shows this :
singleValue :
but when change it to table type:
as you can see the logic is correct and it working fine. but why is it refusing to work as singlevalue in the
new dash studio? is it compatibility issue in the new studio? my goal is to is just to display a nice percentage of failures. I need your help please I am new to splunk
thanks,
Hi @Abdullaziz19,
Your table is returning two fields: Percent_Failure, and count.
You can make the singe value viz use the "Percent_Failure" field by selecting the following under the "Selected Data Field" option:
That way you're specifying the right value to use.
Note that you can also add the "%" character in the dashboard options too - just calculate the numeric value you want to display and set the Unit Label to "%". That way you can also round the number automatically, and set thresholds based on its value.
Cheers,
Daniel
Hi @Abdullaziz19,
Your table is returning two fields: Percent_Failure, and count.
You can make the singe value viz use the "Percent_Failure" field by selecting the following under the "Selected Data Field" option:
That way you're specifying the right value to use.
Note that you can also add the "%" character in the dashboard options too - just calculate the numeric value you want to display and set the Unit Label to "%". That way you can also round the number automatically, and set thresholds based on its value.
Cheers,
Daniel
I followed your steps and it worked like a charm thanks a lot man.