Splunk Search

Accum statement

keyu921
Explorer

My data as following
Location|No.of active
US|200
UK|20
SZ|30

How to accum all those location by month by area chart
I now search as
w search as
|timechart span=1mon count by location| accum us as us| accum uk as uk | accum sz as sz | fields - uk us sz | fillnull

Tags (1)
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@keyu921

Can you please more about your requirement and expected output?

0 Karma

keyu921
Explorer

bar chart that no.active and trend grow for last1yrs timechart span=1month

0 Karma
Get Updates on the Splunk Community!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...