topic Comparing Multiple Years of Max Values in All Apps and Add-ons

Comparing Multiple Years of Max Values

israelgutierrez — Sat, 28 Jun 2014 23:21:53 GMT

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,

Re: Comparing Multiple Years of Max Values

martin_mueller — Sun, 29 Jun 2014 04:29:02 GMT

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

Re: Comparing Multiple Years of Max Values

somesoni2 — Tue, 01 Jul 2014 14:09:18 GMT

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

Re: Comparing Multiple Years of Max Values

israelgutierrez — Tue, 01 Jul 2014 18:39:32 GMT

Thank you thats work