topic Re: Make a dashboard visual from calculated field in Splunk Search

Make a dashboard visual from calculated field

hollybross1219 — Sat, 29 Feb 2020 00:38:47 GMT

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?

Re: Make a dashboard visual from calculated field

to4kawa — Sat, 29 Feb 2020 01:06:47 GMT

 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

Re: Make a dashboard visual from calculated field

hollybross1219 — Mon, 02 Mar 2020 17:45:43 GMT

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

Re: Make a dashboard visual from calculated field

to4kawa — Mon, 02 Mar 2020 21:01:26 GMT

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