Splunk Search

Make a dashboard visual from calculated field

hollybross1219
Path Finder

Splunk n00b here with a question.

I have a query I would like to display on a bar graph dashboard visual. Here is the query:

index=wsi_tax_summary sourcetype=stash partnerId=* error_msg_service=* ein=* ein!="" tax_year=2019 capability=109* 
| eval error_msg_service = case(match(error_msg_service, "OK"), "Success", 1==1, "Fail") 
| stats dc(intuit_tid) as Total by partnerId error_msg_service 
| chart limit=0 useother=f sum(Total) as Total by partnerId error_msg_service 
| eval total_request = Fail + Success 
| eval "Success Rate" = round(((Success/total_request)*100),2) 
| fieldformat "Success Rate"=tostring('Success Rate')+"%" 
| sort "Success Rate"
| fields partnerId "Success Rate"

Since I'm aiming for a bar graph, the values on Y axis should be partnerId and the X axis should be a value called "Success Rate", which I created with several eval statements. When I click into "visual", nothing produces. Looks like I can only do it with a chart or timechart function

Anyone know how I can achieve this?

0 Karma
1 Solution

to4kawa
Ultra Champion
 index=wsi_tax_summary sourcetype=stash partnerId=* error_msg_service=* ein=* ein!="" tax_year=2019 capability=109* 
 | eval error_msg_service = case(match(error_msg_service, "OK"), "Success", 1==1, "Fail") 
 | stats dc(intuit_tid) as Total by partnerId error_msg_service 
 | chart limit=0 useother=f sum(Total) as Total by partnerId error_msg_service 
 | eval total_request = Fail + Success 
 | eval "Success Rate" = round(((Success/total_request)*100),2) 
 | sort "Success Rate"
 | fields partnerId "Success Rate"

I think, you are not n00b .
try Visualization > Bar Chart

View solution in original post

0 Karma

hollybross1219
Path Finder

Hey @to4kawa, thank you. I guess the fieldformat messed up the viz 🙂

0 Karma

to4kawa
Ultra Champion

I see, please accept the answer to close the question.

0 Karma

to4kawa
Ultra Champion
 index=wsi_tax_summary sourcetype=stash partnerId=* error_msg_service=* ein=* ein!="" tax_year=2019 capability=109* 
 | eval error_msg_service = case(match(error_msg_service, "OK"), "Success", 1==1, "Fail") 
 | stats dc(intuit_tid) as Total by partnerId error_msg_service 
 | chart limit=0 useother=f sum(Total) as Total by partnerId error_msg_service 
 | eval total_request = Fail + Success 
 | eval "Success Rate" = round(((Success/total_request)*100),2) 
 | sort "Success Rate"
 | fields partnerId "Success Rate"

I think, you are not n00b .
try Visualization > Bar Chart

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...