Splunk Search

Timechart Per Day With Tick Mark Per Calendar Week

mzorzi
Splunk Employee
Splunk Employee

Ee would like to see a timechart of a chart with a time-based x-axis with a resolution per day, one bar per day but the tick marks and description on that axis shouldn't be the day but the calendar week.

Tags (1)
0 Karma

mzorzi
Splunk Employee
Splunk Employee

This seems to do the trick !

index=_internal source=*splunkd.log earliest=-20d | eval bytes=length(_raw) | eval WTime=strftime(_time,"%W") | eval userLabel=WTime | eval dateday=date_mday."_".date_month."_".date_year | stats max(bytes) as max by userLabel, dateday | eval userLabel="WeekYear=".userLabel | streamstats count by userLabel | eval userLabel=case(count==1,userLabel,count>=2," ") | table userLabel,max 
0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...