All Apps and Add-ons

Comparing Multiple Years of Max Values

israelgutierrez
Path Finder

Hi

I have a dataset with Time, by Day-Month-Year and a Integer value per day, something like this

_time mxo
30-01-2010 6
30-01-2011 8
30-01-2012 3
30-01-2013 5
30-01-2014 9

I want to make some timechart comparing by month over the years, like comparing 2 or more years of maximum number

My first approach was using Timewrap with something like this

host="smo*" earliest=-12m@y latest=-1m@m |timechart span=1Month max(mxo) | timewrap y

But seems out of range or something wrong
External search command 'timewrap' returned error code 255. Script output = "ERROR "'timeunit' argument required, such as d, w, 2m, q, y" "

Maybe someone have a better and working solution,

Tags (3)
0 Karma
1 Solution

somesoni2
Revered Legend

I tried similar thing and the timewrap is somehow not accepting "y" as an option. Though "timewrap 12mon" works. Try following

host="smo*" earliest=-3y@y latest=+y@y  |timechart span=1mon max(mxo) | timewrap 12month

View solution in original post

somesoni2
Revered Legend

I tried similar thing and the timewrap is somehow not accepting "y" as an option. Though "timewrap 12mon" works. Try following

host="smo*" earliest=-3y@y latest=+y@y  |timechart span=1mon max(mxo) | timewrap 12month

israelgutierrez
Path Finder

Thank you thats work

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Note, -12m moves you back twelve minutes, not twelve months... you're probably looking for -12mon.

Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...