Dear community, I have this:
index=*** sourcetype="*********** " Path=*******"
| stats count by HTTPStatusCode. which will display codes 2**,4**, 5**
Percentage fail0.PNG
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
Percentage fail.PNG
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 :
Percentage fail3.PNG
but when change it to table type:
Percentage fail2.PNG
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,
... View more