Splunk Search

Monthly reporting

ccntech
Explorer

I am trying to create a report that will show month over month reporting for web service average response time as a percentage against a threshold

sourcetype="web_logs" `web_resp_index` *
| bucket _time span=month
| stats count as total_count count(eval(resp_time>=500)) as fail_count count(eval(resp_time<500)) as success_count count(eval(resp_time=="")) as null_count by source _time
| eval success_percent=round((resp_count/total_count)*100,2)
| eval _time=strftime(_time, "%b")
| Fields - total_count fail_count success_count null_count


I now have :
source_timesuccess_percent
www1Jan94.6
www1Feb93.2
www1Mar94.3
www2Jan98.5
www2Feb92.4
www2Mar84
 
I am looking to transpose and group so that I have 1 row per source and monthly columns
SourceJanFebMar
www194.693.294.3
www298.592.484
Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| xyseries source _time success_percent

ccntech
Explorer

that worked perfectly!

Wow I cannot believe the power of the community.  you answered the post within about 5 minutes.

Thank you so much.

Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...