Splunk Search

How to use timechart span

sudeep5689
Explorer

I have a query in splunk
index = * STATUS_CODE earliest=-2mon@mon latest=-1mon@mon | fields STATUS_CODE | rex field=_raw "STATUS_CODE:(?.{0,1}\d)"
| eval success=if(status_code in(0,1),1,0) | timechart count as total sum(success) as success
| eval success_rate=round((success/total)*100,3)
| eval success_rate=success_rate + "%" | table _time success_rate | append [search index = * STATUS_CODE earliest=-1mon@mon latest=@mon | fields STATUS_CODE | rex field=_raw "STATUS_CODE:(?.{0,1}\d)"
| eval success=if(status_code in(0,1),1,0) | timechart count as total sum(success) as success
| eval success_rate=round((success/total)*100,3)
| eval success_rate=success_rate + "%" | table _time success_rate]

I want to show the single value visualization displaying the increase/decrease in success_rate, but its not displaying correctly. I mean i need to add a timechart command again but thats not working. Can anyone help

Labels (2)
0 Karma

493669
Super Champion
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...